Lesson 1Parsing dates and making them standard: turning OrderDate into date and time, dealing with different date ways and time areasLearn how to turn raw date and time parts into Qlik dual date values. Deal with many source ways, time areas, and place problems while making standard date fields that help with steady calendar ways.
Using Date#, Timestamp#, and Time#Converting text dates to dual valuesHandling multiple source date formatsManaging time zones and UTC offsetsBuilding canonical OrderDate fieldsLesson 2Connecting to and bringing in CSV files: file paths, how letters are written, separators, and file wizard choicesConnect to CSV files using data links and the file wizard. Set paths, letter writings, separators, and header choices, and change LOAD statements to make sure imports are clean and as expected.
Creating and testing file connectionsUsing the data load file wizardConfiguring delimiters and quotesHandling headers and first data rowManaging encoding and locale issuesLesson 3Writing notes in the load script: how to make clear comments to explain each big part as the project needsLearn how to write notes in Qlik load scripts with good comments, headers, and part markers so people who come later and checkers can quickly get the ways, data sources, and main business rules in the ETL way.
Comment styles: single line and blockHeader blocks for script and major sectionsExplaining business rules in commentsTagging assumptions, TODOs, and risksLesson 4Understanding Qlik Sense and QlikView load script build and run orderUnderstand how Qlik checks script statements, from link setup to last STORE or EXIT. Learn script parts, run order, basic error handling, and how this flow affects data model results and speed.
Main, tabbed sections, and includesTop‑down execution and dependenciesControl statements: IF, FOR, DO WHILEError handling and script logsImpact of order on joins and fieldsLesson 5Making new fields in script: Year, Month, Quarter from OrderDate with Qlik date waysMake new calendar fields like Year, Month, and Quarter from OrderDate using Qlik date ways. Help flexible time checks by making more signs and keys for money year and calendar views.
Extracting Year, Month, and DayBuilding Quarter and MonthNameUsing YearStart and MonthStartFiscal vs calendar date derivationsCreating date keys for link tablesLesson 6Cleaning text in script: TRIM, UPPER/LOWER, Replace, handling empty and making ProductCategory/ProductSubCategory standardClean and make text fields standard in the script using TRIM, case ways, Replace, and empty handling. Make sure ProductCategory and ProductSubCategory values are the same for grouping and linking.
Removing spaces with TRIM and PURGECHARUPPER, LOWER, and PROPER case usageReplacing bad or legacy text valuesHandling null and empty string casesStandardizing product category labelsLesson 7Testing and changing script parts: reload preview, basic small reload, and checking row numbers and check sumsMake a safe way to change scripts, including part reload, basic small reload, and check steps. Compare row numbers and check sum values to make sure changes did not spoil data.
Using limited load for quick testsBasics of incremental reload logicValidating row counts by tableChecksum and hash‑based comparisonsRolling back and versioning scriptsLesson 8Finding fields and checking during load: ways to look at different values, empties, and data kindsLearn ways to check fields during load, looking at different values, empty rates, and guessed data kinds. Use temp tables, RESIDENT loads, and system ways to check data good early.
Counting distinct values per fieldDetecting nulls and empty stringsChecking inferred data typesSampling data with temporary tablesUsing script logs for profilingLesson 9Cleaning numbers and calculations in script: SalesAfterDiscount, ProfitMargin with guards against zero divide and roundingMaster cleaning numbers and calculations in script, including safe math, rounding, and guarding against divide by zero. Make measures like SalesAfterDiscount and ProfitMargin that work well in apps.
Cleaning numeric fields and coercionHandling nulls and nonnumeric valuesDivision‑by‑zero guards in formulasRounding and formatting measuresBuilding SalesAfterDiscount metricLesson 10Using comments, parts, and best ways in the script for easy reading and keepingUse best ways for script easy reading and keeping using comments, logic parts, name standards, and part includes so teams can safely add and fix hard ETL ways.
Organizing tabs and logical sectionsConsistent field and table namingUsing include files for modularitySeparating staging and model layersRefactoring duplicated script logicLesson 11Basic script commands: LOAD, SELECT, INLINE, RESIDENT, DROP, RENAME and their common usesLook at main Qlik script commands used to load and change data. Understand when to use LOAD, SELECT, INLINE, RESIDENT, DROP, and RENAME, and how they join to make good, keepable ETL pipes.
LOAD vs SELECT: when and whyUsing INLINE for small reference tablesRESIDENT loads for transformationsDROP and RENAME to tidy data modelPreceding LOAD patterns and benefitsLesson 12Handling missing, bad, and odd values in script: if ways, NULLVALUE, and simple fill waysHandle missing, bad, and odd values with if ways and NULLVALUE settings. Make simple fill and cap ways that keep data whole while not making wrong measures.
Configuring NULLVALUE and NullInterpretIF and Alt for conditional handlingTreating negative quantities and pricesSimple mean and median imputationsCapping extreme outliers in metrics
