Qlik Sense System Functions

Last updated on Nov 06 2021
Debodeep Mukherjee

Table of Contents

Qlik Sense System Functions

Following are the Qlik Sense System Functions with examples. Let’s discuss them intimately –

  1. Author() function in Qlik Sense

The author() function returns the knowledge regarding the author of the present Qlik Sense application as a string. The author’s properties of a Qlik Sense app are the small print of that Qlik Sense authorized user which has created the concerning app. you’ll use this function both within the data load script and within the chart expressions.

The syntax for Author Qlik Sense System Functions :

  1. Author()
  2. ClientPlatform() Function

The ClientPlatfom() function returns a string containing the knowledge about the client’s browser.

The syntax for ClientPlatform QliK Sense System Functions:

  1. ClientPlatfom()

A sample response to the present function are often , Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36

iii. ComputerName() function

This function will return a string having the name of your computer. This information are going to be provided by the OS . you’ll use this function both within the data load script and within the chart expressions in Qlik Sense.

Recommended Reading – Qlik Sense Gauge Chart

The syntax of ComputerName Qlik Sense System Functions:

  1. ComputerName()

For instance, this function will return the string ‘Windows-PC’ if the name of your computer is Windows-PC.

  1. DocumentName() function

This function when used, will return a string which contains the name of the present Qlik Sense document with the acceptable extension (.qvf). Note that this function doesn’t return the whole path of the Qlik Sense document but just the document name with extension.

The syntax of DocumentName Qlik Sense System Functions:

  1. DocumentName( )

For instance, if the name of a Qlik Sense document is Sales Analysis. Then this function will return the string ‘Sales Analysis.qvf’.

  1. DocumentPath() function

This function returns a string having the entire path of a Qlik Sense document. you’ll use this function both within the data load script and chart expression.

The syntax for DocumentPath Qlik Sense System Functions :

  1. DocumentPath( )

For instance, if the trail to a Qlik Sense document named Costumer Sales is C:\Users\HP\Documents\Qlik\Sense\Apps\Consumer Sales.qvf, then this function will return exactly this during a string.

We recommend you to find out Qlik Sense Box Plot

  1. DocumentTitle() function

The documenttitle() function returns a string with just the title of a Qlik Sense document. you’ll use this function both within the data load script and chart expression.

The syntax for DocumentTitle Qlik Sense System Functions:

  1. DocumentTitle()

For instance, if the title of your Qlik Sense document or app is Costumer Sales, then this function will return the string ‘Costumer Sales’.

vii. EngineVersion() function

This function returns a string having the version of the Qlik Sense engine you’re using.

The syntax for EngineVersion QliK Sense System Functions:

  1. EngineVersion()

For instance, if you’re using Qlik Sense version 3.2 then this function will return a string saying ‘Qlik Sense 3.2’.

viii. GetCollationLocale() function

This function returns a string having the culture name of the collation locale getting used by you. For this function to return the culture name, you would like to line the variable CollationLocale to a worth , and if not set, you’ll get the particular user machine locale as a result.

The syntax for GetCollationLoacle Qlik Sense System Functions:

  1. GetCollationLocale()
  2. GetObjectField() function

This function returns a dimension or field of a specific table.

You must read Qlik Sense Conditional Functions

The syntax for GetObjectField Qlik Sense System Functions:

  1. GetObjectField([Index])

Where, Index is that the parameter, using which you’ll specify which dimension or field you would like this function to return. The Index is an integer value.

For instance, you’ve got three dimensions during a table, ProductLine, ProductCategory and StoreLocation. Then by using the expression,

GetObjectField([3]) you’ll get the solution , ‘StoreLocation’.

  1. GetRegistryString() function

This function returns the worth of a specific key within the Windows registry. Registry keys are a bit like folders containing information regarding Windows registory. The values are like files inside the folders containing detailed information regarding an equivalent . Registry values are often string values, binary values etc. Though, this function returns only the string value for a concerning key.

The syntax for GetRegistryString Qlik Sense Functions:

  1. GetRegistryString(path, key)

Where, path is that the path of the registry folder and key’s the precise key whose value you would like to urge as a results of this function.

For example,

  1. GetRegistryString(HKEY_CURRENT_USER\ControlPanel\Keyboard\KeyboardSpeed, KeyboardSpeed)

Returns the worth of the key ‘KeyboardSpeed’ which is 31.

  1. IsPartialReload() function

This function returns a Boolean value (True or False) upon evaluating whether the present reload is partial or not. If yes or True, then this function returns -1 and if False, then 0 is returned.

The syntax for IsPartialReload Qlik Sense System Functions:

  1. IsPartialReload()

xii. OSUser() function

The OSUser() function returns a string with the name of the user which is currently using the OS or is currently connected on Qlik Sense. you’ll use this function both within the data load script and chart expression.

Recommended Reading Qlik Sense Counter Functions

The syntax for OSUser Qlik Sense System functions:

  1. OSUser()

xiii. ProductVersion() function

This function returns a string having the entire detail of the version of Qlik Sense which is currently getting used . Although, this function is like the EngineVersion() function which is preferred over the ProductVersion() function.

The syntax for Productversion Qlik Sense System Functions:

  1. ProductVersion()

xiv. ReloadTime() function

The ReloadTime() function returns the timestamp of the last instant when the info load happened . you’ll use this function both within the data load script and chart function.

The syntax for RelaodTime Qlik Sense System Functions:

  1. ReloadTime()
  2. StateName() function

This function returns the name of the alternate state which is employed for a visualization. Alternate states are used for dynamic texts or dynamic colors i.e. when the visualization changes its state depending upon some factors or selections within the Qlik Sense document.

The syntax for StateName Qlik Sense System Functions:

  1. StateName()

Example,

  • For dynamic text-
  1. =’Region – ‘& if(StateName() = ‘, ‘Default’, StateName())
  • For dynamic colors-
  1. if(StateName() = ‘Group 1’, rgb(152, 171, 206),
  2. if(StateName() = ‘Group 2’, rgb(187, 200, 179),
  3. rgb(210, 210, 210)
  4. )
  5. )

Qlik Sense Ranking Functions

  1. Rank() function

The rank() function is employed to rank the values during a dimension contained in rows. Values in each row are evaluated and compared with values within the other rows within an equivalent dimension or field. So, after the comparison of values within the rows, the rows or corresponding values are ranked on the idea of how big or small the worth is as compared to other values. for instance , 100 are going to be ranked 1st and 95 are going to be ranked 2nd then on. This function returns a worth in dual format i.e. in both text and numeric representation.

Recommended Reading – Qlik Sense Treemap Visualization

Syntax:

  1. Rank([TOTAL] expr[, mode[, fmt]])

Where, expr is that the dimension or field whose rows or values you would like to sort and rank.

Mode sets the amount representation of the rank returned by the function. you’ll set this parameter in several ways like ,

0 which is that the default value and assigns a rank to values counting on which side of the center value they fall on. Basically, if a worth falls on the lower side of the center value then it returns rock bottom rank number. And if the worth falls on the upper side of the center value then the function returns the very best rank value.

Other values also can be set like 1 (lowest rank), 2 (average rank), 3 (highest rank on all rows) and 4 (for lowest rank on the primary row then one rank incremented for every new value).

Fmt sets the text representation of the rank returned by the function. Several values are often set for this parameter like, 0 which is that the default value signifying a variety of low value- high value. 1 for low value on all rows and a couple of for low value on the primary row then blank on all the opposite .

The TOTAL prefix or qualifier if used evaluates all the columns or dimensions of a table and included only those values in evaluation which are an equivalent because the value it’s evaluating within the current row.

For instance, we’ve a knowledge record with fields like Customer and Sales. The rows within the fields have sales values for respective customers. Using the rank function Rank(Sales) we are getting to create a measure field within the table which can be ranking of sales values either sorted on Customer or on Sales.

So, as are often seen within the table given below, the values are sorted on the idea of Customer then all the values like Benedict are going to be evaluated and ranked first. the first rank is given to the very best value, 88. The ranks descend with the decrease within the value. So, after evaluation of Benedict’s values is complete, then Ethan is haunted for evaluation. rock bottom value associate to Ethan is 12 and hence, rock bottom rank 10 is given thereto .

, ‘Default’, StateName())

  • For dynamic colors-
  1. if(StateName() = ‘Group 1’, rgb(152, 171, 206),
  2. if(StateName() = ‘Group 2’, rgb(187, 200, 179),
  3. rgb(210, 210, 210)
  4. )
  5. )

Qlik Sense Ranking Functions

  1. Rank() function

The rank() function is used to rank the values in a dimension contained in rows. Values in each row are evaluated and compared with values in the other rows within the same dimension or field. So, after the comparison of values in the rows, the rows or corresponding values are ranked on the basis of how big or small the value is as compared to other values. For example, 100 will be ranked 1st and 95 will be ranked 2nd and so on. This function returns a value in dual format i.e. in both text and numeric representation.

Recommended Reading – Qlik Sense Treemap Visualization

Syntax:

  1. Rank([TOTAL] expr[, mode[, fmt]])

Where, expr is the dimension or field whose rows or values you want to sort and rank.

Mode sets the number representation of the rank returned by the function. You can set this parameter in several ways such as,

0 which is the default value and assigns a rank to values depending on which side of the middle value they fall on. Basically, if a value falls on the lower side of the middle value then it returns the lowest rank number. And if the value falls on the higher side of the middle value then the function returns the highest rank value.

Other values can also be set like 1 (lowest rank), 2 (average rank), 3 (highest rank on all rows) and 4 (for lowest rank on the first row then one rank incremented for each new value).

Fmt sets the text representation of the rank returned by the function. Several values can be set for this parameter like, 0 which is the default value signifying a range of low value- high value. 1 for low value on all rows and 2 for low value on the first row then blank on all the other.

The TOTAL prefix or qualifier if used evaluates all the columns or dimensions of a table and included only those values in evaluation which are the same as the value it is evaluating in the current row.

For instance, we have a data record with fields like Customer and Sales. The rows in the fields have sales values for respective customers. Using the rank function Rank(Sales) we are going to create a measure field in the table which will be ranking of sales values either sorted on Customer or on Sales.

So, as can be seen in the table given below, the values are sorted on the basis of Customer and so all the values corresponding to Benedict will be evaluated and ranked first. The 1st rank is given to the highest value, 88. The ranks descend with the decrease in the value. So, after evaluation of Benedict’s values is complete, then Ethan is taken up for evaluation. The lowest value associate to Ethan is 12 and hence, the lowest rank 10 is given to it.

You must read – Qlik Sense Pie Chart

Customer Sales Rank (Sales)
Benedict 12 9
Benedict 28 7
Benedict 45 6
Benedict 58 5
Benedict 60 4
Benedict 65 3
Benedict 70 2
Benedict 88 1
Ethan 12 10

If, the table is sorted on Sales, then for any sales value which is same for two customers, the rank would be 1-2 and for those values for which the sales value is unique, the rank is 1.

Customer Sales Rank(Sales)
Benedict 12 1-2
Ethan 12 1-2
Benedict 25 1
Ethan 34 1
Benedict 45 1
Benedict 48 1-2
Ethan 48 1-2
Ethan 56 1-3
Joshua 56 1-3
Mathew 56 1-3

 

As you’ll see, when a sales value, say, 12, is common between two customers Benedict and Ethan, then the rank is given as 1-2. And when the sales value 56 is which is common between three customers, Benedict, Joshua, and Ethan, then rank is 1-3.

Do you realize Qlik Sense Mathematical Functions

  1. HRank() function

The HRank() function may be a function exclusively used for pivot tables and returns NULL if utilized in the other visualization. This function evaluates a worth given during a row of a column during a pivot table and ranks it consistent with the values within an equivalent row segment in other columns. So, the result are going to be rank of the currently evaluated value amongst the whole row segments (i.e. evaluating values of a row horizontally).

Syntax:

  1. HRank([ TOTAL ] expr [ , mode [, fmt ] ])

Where, expr is that the dimension or field whose rows or values you would like to sort and rank.

Mode sets the amount representation of the rank returned by the function. you’ll set this parameter in several ways like ,

0 which is that the default value and assigns a rank to values counting on which side of the center value they fall on. If a worth falls on the lower side of the center value then it returns rock bottom rank number. And if the worth falls on the upper side of the center value then the function returns the very best rank value.

Other values also can be set like 1 (lowest rank), 2 (average rank), 3 (highest rank on all rows) and 4 (for lowest rank on the primary row then one rank incremented for every new value).

Fmt sets the text representation of the rank returned by the function. Several values are often set for this parameter like, 0 which is that the default value signifying a variety of low value- high value. 1 for low value on all rows and a couple of for low value on the primary row then blank on all the opposite .

So, the entire prefix or qualifier if used evaluates all the columns or dimensions of a table and included only those values in evaluation which are an equivalent because the value it’s evaluating within the current row.

For example, if we’ve sales values of various customers, we will rank them on the idea of their performance (total sales are done).

Customer Year Sales Hrank(Sales)
Benedict 2017 $28,000 3
Ethan 2017 $20,000 4
Joshua 2017 $36,000 2
Mathew 2017 $45,000 1
Benedict 2018 $26,000 4
Ethan 2018 $29,000 3
Joshua 2018 $32,000 2
Mathew 2018 $35,000 1

 

We have made the four customer names in vertical order (like during a crosstable) but within the pivot table, all four were a part of an equivalent row, occurring horizontally.

What is QliK Sense Geospatial Functions?

The QliK Sense Geospatial Functions have two categories, aggregation and non-aggregation functions. The aggregation geospatial functions absorb a group of geospatial data as input and return one return which is that the aggregation of all. as an example , you’ll provide the coordinates of multiple areas and therefore the function would return one boundary aggregating all the multiple boundaries.

Whereas, non-aggregation functions absorb single data points as input and return one result value. Thus, no aggregation involves here. Below, are the functions under each category.

  1. Aggregation QliK Sense Geospatial Functions
  2. GeoAggrGeometry

This function takes during a number of area data points as input and returns the aggregated area i.e. a bigger area as a result. you’ll use multiple sub-regions or suburb area boundaries as input values and this function will return a cumulative boundary or a much bigger region adding up the boundaries of the sub-regions or suburbs. This function is of great significance once we want to research a business trait during a territory comprising of multiple data points, as this function will apply aggregation on all the individual data points and return a territory.

Syntax for QliK Sense Geospatial Functions –

  1. GeoAggrGeometry(field_name)

Where, field_name is that the name of the sector which contains individual data points or values which are taken as input values for aggregation.

For example, within the sample script given below, the world points for individual areas are loaded within the field world.Areas which is aggregated by the GeoAggrGeometry(world.Areas) from the table ‘worldareas’ which may be a KML file. this may return the aggregated area within the newly created field called AggrArea. Also, it’s important to use the Group By clause during a data load statement.

  1. [MapSource]:
  2. LOAD [world.Name],
  3. [world.Points],
  4. [world.Areas]
  5. FROM [lib://Downloads/worldareas.kml]
  6. (kml, Table is [Worldareas.shp/Features]);
  7. Map:
  8. LOAD world.Name,
  9. GeoAggrGeometry(world.Areas) as [AggrArea]
  10. resident MapSource Group By world.Name;
  11. GeoBoundingBox

This function takes during a number of knowledge points of a neighborhood and returns the worth of 4 coordinates which makes the littlest bounding box or the coordinates making the littlest rectangle.

Have a glance at Qlik Sense Integer Functions

Syntax for QliK Sense Geospatial Functions:

  1. GetBoundingBox(field_name)

Where, field_name is that the name of the sector which contains all the geospatial data values like a neighborhood . The values are a group of points representing the latitude, longitude, or i.e. the coordinates marking area points.

iii. GeoCountVertex

This function returns the amount of vertices present during a polygon geometry.

Syntax for QliK Sense Geospatial Functions:

  1. GetCountVertex(field_name)

Where, field_name is that the name of the sector which contains all the geospatial data values like a neighborhood . The values are a group of points representing the latitude, longitude, or i.e. the coordinates marking area points.

  1. GeoInvProjectGeometry

This function returns the inverse of a projection of a geometry originally aggregating the given set of knowledge points.

Syntax for QliK Sense Geospatial Functions:

  1. GeoInvProjectGeometry(type, field_name)

Where, type is that the sort of projection or geometry during which the prevailing geometry of the map are going to be transformed. There are two sorts of projections, ‘unit’ which is about by default and returns a 1:1 projection, and therefore the other is ‘mercator’ which returns the quality Mercator projection of the aggregated area.

Recommended Reading – QliK Sense Financial Functions

field_name is that the name of the sector which contains all the geospatial data values like a neighborhood . The values are a group of points representing the latitude, longitude, or i.e. the coordinates marking area points.

For example, within the piece of code given below, is given a loaded statement which contains the world coordinates within the field ‘PolygonArea’. The geometry contained during this field will transform into the inverse of Mercator projection . The transformed geometry is then stored within the field, ‘InvProjectGeometry’.

GeoInvProjectGeometry(‘mercator’,PolygonArea)as InvProjectGeometry

  1. GeoProjectGeometry

This function applies a projection on a geometry which was aggregating from the given set of knowledge points.

Syntax for QliK Sense Geospatial Functions:

  1. GeoProjectGeometry(type, field_name)

Where, type is that the sort of projection or geometry during which the prevailing geometry of the map are going to be transformed. There are two sorts of projections, ‘unit’ which is about by default and returns a 1:1 projection, and therefore the other is ‘mercator’ which returns the quality Mercator projection of the aggregated area.

field_name is that the name of the sector which contains all the geospatial data values like a neighborhood . The values are a group of points representing the latitude, longitude, or i.e. the coordinates marking area points.

For example, within the piece of code given below, is given a load statement which contains the world coordinates within the field ‘PolygonArea’. This function will apply the Mercator projection on the geometry of the aggregated data points given within the field PolygonArea. The applied projection is then stored within the field, ‘ProjectGeometry’.

GeoInvProjectGeometry(‘mercator’,PolygonArea)as ProjectGeometry

Know more about Qlik Sense Table Functions

  1. GeoReduceGeometry

This function returns the reduced area of a bigger area created from aggregating variety of knowledge points. The individual area boundaries still shows on the map even after the reduction of the world as an entire .

Syntax for QliK Sense Geospatial Functions:

  1. GeoReduceGeometry(field_name[, value])

Where, field_name is that the name of the sector which contains all the geospatial data values like a neighborhood . The values are a group of points representing the latitude, longitude, or i.e. the coordinates marking area points.

Value sets the quantity of reduction you would like to use on the entire area or geometry. you’ll use any value starting from 0 to 1 where, 0 corresponds to the no reduction, and 1 corresponds to maximum reduction. Any decimal value between these two will cause reduction like it.

For example, within the sample script given below, the world points for individual areas are loaded within the field world.Areas which is reduced by 0.5 using the function GeoReduceGeometry(world.Areas). the sector exists within the table ‘worldareas’ which may be a KML file. this may return the aggregated area within the newly created field called ReducedArea. Also, it’s important to use the Group By clause during a data load statement.

  1. [MapSource]:
  2. LOAD [world.Name],
  3. [world.Points],
  4. [world.Areas]
  5. FROM [lib://Downloads/worldareas.kml]
  6. (kml, Table is [Worldareas.shp/Features]);
  7. Map:
  8. LOAD world.Name,
  9. GeoReduceGeometry(world.Areas,0.5)as [ReducedArea]
  10. resident MapSource Group By world.Name;
  11. Non-aggregation Qlik Sense Geospatial Functions
  12. GeoGetBoundingBox

This function calculates the littlest possible geospatial bounding box enclosing all the coordinates of a neighborhood or geometry. This function returns a string having four values, which are right, left, top, and bottom coordinates of the bounding box.

You must read QliK Sense Date and Time Functions

Syntax for QliK Sense Geospatial Functions:

  1. GeoGetBoundingBox(field_name)

Where, field_name is that the name of the sector which contains all the geospatial data values like a neighborhood . The values are a group of points representing the latitude, longitude, or i.e. the coordinates marking area points.

We use this function in chart and script expressions.

  1. GeoGetPolygonCenter

This function returns a string which contains the longitude and latitude value of the middle of a polygon or of any geometric area/shape enclosed in boundaries.

Syntax for QliK Sense Geospatial Functions:

  1. GeoGetPolygonCenter(field_name)

Where, field_name is that the name of the sector which contains all the geospatial data values like a neighborhood . The values are a group of points representing the latitude, longitude, or i.e. the coordinates marking area points.

iii. GeoMakePoint

This function returns some extent on the map by the latitude and longitude values provided within the function itself. The points returns with the coordinates like the longitude and latitude, therein order.

Syntax for QliK Sense Geospatial Functions:

  1. GeoMakePoint(lat_field_name, lon_field_name)

Where, lat_field_name is that the field or expression which provides the latitude values.

lon_field_name is that the field or expression which provides the longitude values.

  1. GeoProject

This function applies a projection to a geometry or area.

Let’s discuss the Qlik Sense Mathematical functions

Syntax for QliK Sense Geospatial Functions:

  1. GeoProject(type, field_name)

Where, type is that the sort of projection or geometry during which the prevailing geometry of the map are going to be transformed. There are two sorts of projections, ‘unit’ which is about by default and returns a 1:1 projection, and therefore the other is ‘mercator’ which returns the quality Mercator projection of the aggregated area.

field_name is that the name of the sector which contains all the geospatial data values like a neighborhood . The values are a group of points representing the latitude, longitude, or i.e. the coordinates marking area points.

For example, within the piece of code given below, is given a load statement which contains the world coordinates within the field ‘Area’. This function will apply the Mercator projection on the geometry of the sector Area. The applied projection is then stored within the field, ‘GetProject’.

  1. GeoProject(‘mercator’,Area) as GetProject

So, this brings us to the end of blog. This Tecklearn ‘Qlik Sense System Functions’ blog helps you with commonly asked questions if you are looking out for a job in Qlik Sense BI. If you wish to learn Qlik Sense and build a career in Business Intelligence domain, then check out our interactive, Qlik Sense Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/qlik-sense-certification-training/

Qlik Sense Certification Training

About the Course

Qlik Sense is a revolutionary Business Analytics tool to come from the Qlik stables. It provides powerful self-service analytics that are readily deployable through interactive and personalized dashboards, data visualization techniques and insightful reports. By the end of this Qlik Sense online training, you will be able to perform key skills of the self-service BI tool – Qlik Sense, such as self-service analytics, write data load scripts, data discovery, create dashboards, develop and share apps, create reports, and design and build data visualizations. All these skills will enable you to clear the Qlik Sense certification exam.

Why should you take Qlik Sense Training?

  • The average annual pay for a Qlik Sense Professional is $101,871. -Indeed.com.
  • HSBC, Alstom, Chrysler, Citibank, Accenture and many other MNC’s worldwide use Qlik Sense BI and it has a market share of around 5% globally.
  • By the end of 2020, the market is expected to touch USD 22.8 billion as modern BI and analytics continue to expand more rapidly, Gartner said in a report.

What you will Learn in this Course?

Introduction and Installation of Qlik Sense

  • Need for self-service Business Intelligence/Business Analytics
  • Installation of Qlik Sense and Qlik Sense Desktop

Qlik Sense Features

  • Qlik Data indexing engine
  • Data dimensions relationships
  • Types of Data Loading
  • Types of Concatenation

Data Modelling

  • Qlik Sense data architecture
  • Understanding QVD layer
  • Converting QlikView files to Qlik Sense files
  • Incremental Load
  • Scripting
  • Create Master Calendar

Advance Data Modelling

  • Qualify and unqualify
  • Joins
  • Keep
  • Cross Table
  • Let Vs Set
  • Calendar Table Creation

Qlik Sense Enterprise

  • Various Functions
  • Create QVD Files
  • Read Data for QVD Files
  • Create QVD’s
  • Create Tier 2 Qlik Sense App

Data Visualization

  • Expressions
  • Variables
  • Extensions
  • Data Visualization

Set Analysis

  • Set analysis in Qlik Sense
  • Use set expression like identifiers, operators, modifiers and comparative analysis

Advance Set Analysis

  • Deploy comparison sets and perform point-in-time analysis

Qlik Sense Storytelling

  • Storytelling feature of Qlik Sense
  • Create a story and playback the story

Qlik Sense Visualization

  • Qlik Sense Charts
  • Advanced Charts
  • Creating Dashboards
  • Real Life Examples

Security

  • Security aspects of Qlik Sense
  • Security rules

Got a question for us? Please mention it in the comments section and we will get back to you.

 

 

0 responses on "Qlik Sense System Functions"

Leave a Message

Your email address will not be published. Required fields are marked *