Discussion board where members can get started with Qlik Sense.
I'm new to Qlik and I'm trying to make some very basic visualizations.
I have a problem counting 'DOSSIERNR' when I put the formula in a variable.
The variable is defined as follows: vCntDosNr and the definition is =count(DOSSIERNR)
For some reason, the count variable is returning the total for every records while the 'other' count is correct.
Thanks for your assistance because I can't figure it out where it goes wrong.
If I insert this variable in a table with a specific dimension, then the grand total is returned for every level of the dimension.
Go to Solution.
Remove the = (equal sign) from your Definition and it should be fixed
Count(DOSSIERNR) instead of =Count(DOSSIERNR)
Check this link out
The Magic of Variables
Thanks! Works fine now.
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).
If not, please make clear what part of this topic you still need help with .