Count variable returning grand total on every line

[Anonymous]

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.

[sunny_talwar · Accepted solution]

Remove the = (equal sign) from your Definition and it should be fixed

Count(DOSSIERNR) instead of =Count(DOSSIERNR)

[sunny_talwar]

Check this link out

The Magic of Variables

[Anonymous]

Hi Sunny,

Thanks! Works fine now.

[oknotsen]

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 .