How to make bucketing in Frontend...

[Anonymous]

Hi

I have attached the data Set below & also the app which i have made in Qlik Sense. So can you please tell me how to to this and also i want to make the below charts in my app.

[rahulpawarb]

Hello Gulshan,

Trust that you are doing well!

You can refer below given expression on the dimension field present in the Bar Chart (Day field as Dimension):

=Replace(Class(Day, 10),'<= x <', '-') & 'Days Bucket'

Hope this will help.

Regards!

Rahul

[Anonymous]

Hi Rahul,

Can you explain me the whole scenario. Actually the difference between each bucket is not equal so how can i write the code. and i want to calculate the bucketing on outstanding Amount

[Anonymous]

Actually below are my requirements. First one i have already done. the rest two are pending which requires bucketing. and i have calculated the outstanding amount on frontend bu set analysis. can you help in rest of the two

[ChennaiahNallani]

D -- Replace(Class(Day, 10),'<= x <', '-') & 'Days Bucket'

M --- Sum(Amount)

[rahulpawarb]

Hello Gulshan,

In case of uneven buckets you can write the calculated dimension as (Result of Today()-[Invoice Date] will give us the Days overdue):

If(Today()-[Invoice Date] >=0 AND Today()-[Invoice Date]<=100, '0-100 Days Bucket', 
If(Today()-[Invoice Date] >=101 AND Today()-[Invoice Date]<=300, '101-300 Days Bucket',
If(Today()-[Invoice Date] >=301 AND Today()-[Invoice Date]<=500, '301-500 Days Bucket', 
'More than 500 Days Bucket')))

Post this you can use below given expression for Total Outstanding Amount:

SUM({$<FLAG = {'Invoice'}>}Amount) - SUM({$<FLAG = {'Collection'}>}Amount)

For further details please refer below given link:

Buckets

If you still have any issues then please let me know.

Regards!

Rahul

[Anonymous]

Hi Rahul,

It is working Properly but one thing is not working i.e. color coding. When I applied color by dimension then it gives me the same color on every bar and the legends are not there even if i already selected the show legends option. below is the screenshot of the chart that I made :-