Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wim_embrechts
New Contributor III

Count variable returning grand total on every line

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

count variable.PNGtable with 3 counts.PNGIf I insert this variable in a table with a specific dimension, then the grand total is returned for every level of the dimension.

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Count variable returning grand total on every line

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

Count(DOSSIERNR) instead of =Count(DOSSIERNR)

4 Replies
MVP
MVP

Re: Count variable returning grand total on every line

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

Count(DOSSIERNR) instead of =Count(DOSSIERNR)

MVP
MVP

Re: Count variable returning grand total on every line

Check this link out

The Magic of Variables

wim_embrechts
New Contributor III

Re: Count variable returning grand total on every line

Hi Sunny,

Thanks! Works fine now.

oknotsen
Honored Contributor III

Re: Count variable returning grand total on every line

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 .

May you live in interesting times!