4 Replies Latest reply: May 22, 2017 7:11 AM by Onno van Knotsenburg RSS

    Count variable returning grand total on every line

    Wim Embrechts



      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.




      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.