# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save \$400. Learn More
Highlighted
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

If 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

## 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

## 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

## Re: Count variable returning grand total on every line

Check this link out

The Magic of Variables

New Contributor III

## Re: Count variable returning grand total on every line

Hi Sunny,

Thanks! Works fine now.

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!