5 Replies Latest reply: May 29, 2013 7:09 AM by Yannick Durand RSS

    Calculate Number of Invoice and Item Repetition

    Ashkan Darabi

      Hi all

       

      I'm new to Qlikview.

       

      I have a table like this:

       

      Item CodeInvoice No.
      A111
      B111
      D112
      A113
      C114
      C114
      C114

       

      Now I want codes for:

       

      1- Number of issued invoice: (Answer is 4)

       

      2- Item repetition

      Answer:

      Item CodeRepetition
      A2
      B1
      C3
      D1

       

      Please help me.

       

      Thank you in advance.

       

      Regards,

      Ashkan