Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi
You can go through this link https://community.qlik.com/docs/DOC-5727
there are lot of samples available in this qvw
Vikas
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;
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
Well you can set a Variable for the outstanding amount and Use class function to get bucket