Search by Keyword
Sense Excel the Add-In for Microsoft
If you miss something please send us an email. Thanks!
Add a Column (Dimension, Measure, Formula)
Add you cols how you like
See below:
Add and select your dimensions and measure (multi add allowed) from your data model / Qlik Sense App
Hit the “green” button and you will see preview of the row count on the top! In this example row count is “17”
You can add measures with stand Qlik script syntax also
In a script, the name of the data source, the names of the tables, and the names of the fields included in the logic are defined. Furthermore, the fields in the access rights definition are defined in the script. A script consists of a number of statements that are executed consecutively. The Qlik Sense command line syntax and script syntax are described in a notation called Backus-Naur Formalism, or BNF code. Standard quik functions are:
- Sum()
- Count()
- Avg()
- Min()
- Max()
- Only()
More infos you will find here: https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/script-syntax.htm
No Comments