topic Re: Scorecard- Comparing data for two months in QlikView

Scorecard- Comparing data for two months

Thu, 12 Dec 2013 15:03:22 GMT

Hi ,

I am working on a project to create a Data Quality scorecard for one of our process and would like to compare the performance on month on month basis.I have data for two months and have created two individual .qvw files but would like to know if this can be done in one file.

Want to check if this can be done using an expression or should it be done using a different method.

The data-set that I have is the Actual(Raw) data and exception data ( data which had failed rules).

Regards

Venkatesh

Re: Scorecard- Comparing data for two months

Josh_Good — Thu, 12 Dec 2013 18:19:00 GMT

This can be done using expressions in a single QVW. Take a look at "Set Analysis". Using set analysis you can essentially override selections. For example you could select on a specific month and have the expression return the results from the previous month.

For example: Sum({$<Month = {$(=AddMonths(Max(Month),-1))}> Sales)

Will take the Max Month in the selections, 'change' the selection to the previous month and then sum the sales.