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

      Dries