topic Trend Reporting For The Prior 12 months in QlikView

Trend Reporting For The Prior 12 months

Mon, 08 Mar 2010 21:16:25 GMT

I have search a variety of .qvw files and this forum on how to determine a routine which would act as follows:

My application wishes to produce a mini chart sparkline of say total sales for the prior 12 months based upon a year select by the user via a year value select fron a List box. Should the user also select a month value from another List box, then the sparkline would reflect the prior 12 months ending in the year and month selected by the user.

Does anyone know of any examples or solutions I can look at?

Trend Reporting For The Prior 12 months

Tue, 09 Mar 2010 00:03:48 GMT

combination of set analysis, variables and some qv expertise do the job:P Please see attached file.

Cheers

Trend Reporting For The Prior 12 months

Wed, 10 Mar 2010 19:34:58 GMT

Thanks for the sample .qvw. I will look at it and see if I can make it work for my task.

Thanks again.