doubt in debtors application - Qlik Community

Anonymous · ‎2017-03-01

I have a dataset of Debtors. Two tables or sheets are there first is Invoice table which consists of invoice amount & credit notes raised on individual invoice no. and the second is Collections which consists of collection done on particular invoice no.

BRD are:-

1.) To calculate the outstanding amount :- which I did by using the Set analysis on the frontend. now i want bucketing on the outstanding amount but i am not able to do that because i have not calculated the outstanding amount on the backend & Set analysis only works on the frontend. So can You please suggest how can i do bucketing now.

I have attached My App and the dataset below :-

i want this type of bucketing :-

Can anyone please help me in this...

vikasmahajan · ‎2017-03-02

Hi

You can go through this link https://community.qlik.com/docs/DOC-5727

there are lot of samples available in this qvw

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

rupamjyotidas · ‎2017-03-02

Maybe use mixture of class function and set analysis in front end.

But I would really like it to be done on script to make the front end simple, but again to do it in script you might have to calculate the 'outstanding amount' in script;

Anonymous · ‎2017-03-02

Hi Rupam,

Actually I have already calculated the outstanding amount on Front end by using set analysis.So that is why i want to make Bucketing on frontend on outstanding amount

rupamjyotidas · ‎2017-03-03

Well you can set a Variable for the outstanding amount and Use class function to get bucket

Class function