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

      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.