topic Re: Date range grouping of data in QlikView

Date range grouping of data

varunicious — Fri, 26 Jul 2019 19:51:51 GMT

I have a transactions data. I want to create a table having date range with account number and total amount of transactions.

For example:

Data:

Date account Number amount

11-July-19 XYZ 40

11-July-19 ABC 20

12-July-19 XYZ 60

13July-19 XYZ 20

13-July-19 ABC 100

14-July-19 ABC 50

16 July 2019 ABC 40

and so on...

Desired Output for every 5 days interval (Can use a pivot table but unable to get the results):

Date Account Number Amount

11-15 July 2019 ABC 120

11-15 July 2019 XYZ 120

12-16 July 2019 ABC 140

Re: Date range grouping of data

agni_gold — Sat, 27 Jul 2019 21:14:41 GMT

PFA the required output

Re: Date range grouping of data

Brett_Bleess — Tue, 20 Aug 2019 21:01:59 GMT

Varun, did Agni's post and sample app help you get things sorted? If so, please be sure to give them credit by using the Accept as Solution button on the post to mark it. If you did something else, consider posting that and mark it. If you are still working on things, if you can provide an update, others may be able to chime in with other ideas.

Regards,
Brett