Core Developer Knowledge

Range functions produce a single value out of a range of values. For example, getting a max value out of multiple fields. This article will cover the basic principles of…

Numeric functions are used for generic number calculations. This article will cover the basic principles of working with these functions in the data load editor and visualisations, including: The general…

Math functions are used for mathematical applications. This article will cover the basic principles of working with these functions in the data load editor and visualisations, including: The general function…

Logical functions are used to check specific logical criteria. This article will cover the basic principles of working with these functions in the data load editor and visualisations, including: The…

Inter-record functions are used to tell Qlik to use or look at values from rows other than the one currently being read. Some functions can be used to look at…

Interpretation functions are used to inform Qlik on how to read a string if it represents a numeric value. These are particularly useful if your source data dates are formatted…

Geospatial functions are for handling data when using map visualisations. They apply to geospatial data. Some of the functions are aggregating functions. These functions are useful if your business utilises geographical…

Formatting functions are used to format the way integers are displayed in visualisations. All formatting functions return a dual value, which means they will display in a 'user friendly' way…

Financial functions are used to calculate payments and interest rates. They are particularly useful for project evaluation. This article will cover the basic principles of working with financial functions in…