4 Replies Latest reply: Oct 31, 2018 6:31 AM by Dries Clairhout RSS

    Counting lines in table

    Dries Clairhout

      Dear users,


      I have a problem with one of my clients.

      We need to know the number of orders.


      To do this I go to table: KLORDHFD

      In this table there is a collumn KOH-NR wich has all the orderheaders.

      Now to know the number of headers within a selection I need to count all the lines in this collumn.


      I did:


      KOH-NR as CorrectOrder;

      then in the expression in Qlik Sense for visualisation I did count(distinct CorrectOrder);

      But this gives a number 1000x what it should be,

      any help?


      Thanks in advance