Compare previous months data and create aging

chari — Sat, 16 Nov 2024 02:48:57 GMT

Hi ,

I have a data from April to July , I want to compare ID's from all the months and create aging..

Case1 : Compare current month and previous month and take the new ID's from current month (0-30 days)

Case2 : Compare current month and previous month and take the matching ID's from both month (30-60 days)

Case3 : Compare current month and previous two months and take the ID's repeating in all the three months (60-90 days)

In this case ID's should be continuously available in all the 3 months with out any break for example ID is available in July and not available June and again available in May .. so this ID should fall in (0-30 days aging)

Case4 : Compare current month and all previous months and take the ID's repeating in all the months (>90 days).

Could you please help me how to do this..

I want to show this aging in bar chart... Data attached

Re: Compare previous months data and create aging

Brett_Bleess — Mon, 26 Aug 2019 20:38:35 GMT

Kalyan, I was going to dump some specific Design Blog posts in here for you, but I think it may be better to let you poke around the area on your own. The way I usually go about finding things there is search on a single word and see what I get and then use words from those results to try to narrow things down etc. There are some posts on 'buckets' and 'intervalmatch' etc., but I am not sure which way you need to go with things here. Hopefully this may allow you to come up with some ideas to move forward though.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

topic Compare previous months data and create aging in QlikView

Compare previous months data and create aging

Re: Compare previous months data and create aging