Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I want the below report in Qlik Sense. Can anyone please help me in this
I have done this
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
Also I have used class function as user wants dynamic bucketing on the selection of Month
Perhaps this?
=IF(GETSELECTEDCOUNT(MonthName)=0,DUAL('AR Aging ' & REPLACE(CLASS($(vToday)-[Link Date],30) & ' Amount','<= x <','-'),CLASS($(vToday)-[Link Date],30)), DUAL('AR Aging ' & REPLACE(CLASS(vMaxDate-[Link Date],30) & ' Amount','<= x <','-'),CLASS(vMaxDate-[Link Date],30)))
Hi Anil,
Thanks for your reply.
But i am talking about the Bucket limits like what i want is :-
1-30,31-60,61-90...so on (Both upper and lower limits included)
till now i have done is
0-30,30-60,60-90..so on (only upper limit is included)
I suggest you to work on If..Else condition ??
I've tried it but didn't work
is it possible to make unequal buckets on frontend using class functions...?
Kindly reply as I need it on urgent basis.
Kindly reply as I need it on urgent basis