Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Regards,
Wim
If I insert this variable in a table with a specific dimension, then the grand total is returned for every level of the dimension.
Remove the = (equal sign) from your Definition and it should be fixed
Count(DOSSIERNR) instead of =Count(DOSSIERNR)
Remove the = (equal sign) from your Definition and it should be fixed
Count(DOSSIERNR) instead of =Count(DOSSIERNR)
Check this link out
Hi Sunny,
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 .