14 Replies Latest reply: Jun 12, 2018 8:12 AM by Divyanshi Bansal RSS

    How to make Profit% category at front end in qliksense?

    Divyanshi Bansal

      Hi All,

       

      I have two columns:     Customer Group and Customer Name

       

      And I have one radio button:

      radio.PNG

      I want to categorize all customer group as well as customer name on the basis of sum(Profit) depending upon the selection of customer selection filter as:

       

      sum(Profit)<0      ->                                    "<0%"

      sum(Profit)>=0 and sum(Profit)<10      -> "0-10%"

      sum(Profit)>=10 and sum(Profit)<20      -> "10-20%"

      sum(Profit)>=20    ->                                  ">=20%" 


      Also I have one leaders filter , I want when someone selects any leader then grouping should be done corresponding to leaders as well in addition to customer group/customer name.

      filters2.PNG

       

      Kindly help...