topic Re: Aggregation based on file selection: in QlikView

Aggregation based on file selection:

Fri, 26 Feb 2016 22:08:40 GMT

I have a requirement in my project. It would be really great if you could help me with this. I have multiple files and each file contains sales information for three products A, B, C. And I need to aggregate the sales information monthly, quarterly and annually based on file selction which a user would do, for that UI should have a list box containing file names

The sales should be shown in a straight table.

Say when a user selects May 2015 the sales information from May file should be aggregated monthly, quarterly and annually.

Hope this makes sense.

A sample code is greatly appreciated.

Thanks for all the help in the past and for this in advance. Your help means a lot.

Regards,

Roy.

Re: Aggregation based on file selection:

sunny_talwar — Sat, 27 Feb 2016 11:45:49 GMT

Check this link out, this had a very similar requirement:

sales aggregation from multiple excel files

Re: Aggregation based on file selection:

sunny_talwar — Sat, 27 Feb 2016 13:07:00 GMT

Not entirely sure how you are calculating QTD and YTD, but MTD is working. Check it out and explain a little more about QTD and YTD

Re: Aggregation based on file selection:

Sun, 28 Feb 2016 19:49:09 GMT

Thanks Sunny. My requirement is slightly different but I could resolve it based on your qvw.