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)

You are here:
<< Back to all topics

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

Script prefixes

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/script-prefixes.htm

Expample preview  with a row count and with a Qlik syntax “sum(…)”

Edit your cell preview (Dimension, Measure…)

Click on the orange button (fx) and you edit your Qlik script

Submit with the “green” button on the top and you will see the result in your Excel

Change the cell format in direct in Excel – styles formating by Excel self – Click on orange button “Select format”

The Excel number format was changed and submit with “green” button on the top

You see this result table cell number format was changed by Excel self

Or other example:  Add a “TOTAL” column at the end of and use the caculation power from your Qlik Sense system

Was this article helpful?
0 out Of 5 Stars
5 Sterne 0%
4 Sterne 0%
3 Sterne 0%
2 Sterne 0%
1 Sterne 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?
No Comments

Post a Comment

Comment
Name
Email
Website