8 Replies Latest reply: May 31, 2018 8:55 AM by Gulshan Rohilla RSS

    Dynamic bucketing in Qlik Sense

    Gulshan Rohilla

      Hi Guys,

       

      I want the below report in Qlik Sense. Can anyone please help me in this

      bucket1.PNG

       

      I have done this

       

      bucket2.PNG

       

      but as i want the bucket like above. how can i do this. My expression for bucket is :-

      =IF(GETSELECTEDCOUNT(MonthName)=0,DUAL(REPLACE(CLASS($(vToday)-[Link Date],30),'<= x <','-'),CLASS($(vToday)-[Link Date],30)),

      DUAL(REPLACE(CLASS(vMaxDate-[Link Date],30),'<= x <','-'),CLASS(vMaxDate-[Link Date],30)))

       

       

      can anyone help me to achieve the above report.

       

       

      Thanks