1 Reply Latest reply: Aug 3, 2018 12:28 PM by Sunny Talwar RSS

    counting by range

    Wanyun Yang

      I'm trying to create a table in qlik sense which shows sales range and # of customers in each range:

      111.PNG

       

      How can I create sales range in table? What will the function for counting customers be like?

       

      Thanks in advance!

        • Re: counting by range
          Sunny Talwar

          May be try to create buckets here like this

           

          Dimension

          Aggr(If(Sum(Sales) > 100 and Sum(Sales) <= 200, Dual('100-200', 1),

                   If(Sum(Sales) > 200 and Sum(Sales) <= 300, Dual('201-300', 2),

                   If(Sum(Sales) > 300 and Sum(Sales) <= 400, Dual('301-400', 3), Dual('401+', 4)))), Customer)

           

          Expression

          Count(DISTINCT Customer)