topic Re: Comparing selected data with previous data in QlikView

Comparing selected data with previous data

Tue, 12 Mar 2013 07:55:47 GMT

Hi Guys,

I have a table with Revenue numbers with dates and months. I want to compare the selected Revenue numbers with the previous Revenue numbers. (SELECTED_REV / PREVIOUS_REV)

For eg. if i have selected Mar then I would like to Compare Revenue in March compared to Revenue in Feburary (MAR_REV / FEB_REV). If the user sellects March and April then it should be compared with Jan and Feb.

I dont want to hard code it for any fixed duration. Any ideas?

Re: Comparing selected data with previous data

kaushiknsolanki — Tue, 12 Mar 2013 08:02:00 GMT

Hi,

Try below function to get the previous month data.

Consider you have Month,Year and Date as field name.

Sum{<Month = {"$(=month(addmonths(Max(Date),-1)))"},Year=,Date=>}Sales)

Regards,

Kaushik Solanki

Re: Comparing selected data with previous data

Tue, 12 Mar 2013 09:27:38 GMT

Thanks Kaushik,

This works for a single selection but when I choose multiple months then it doesnt give the correct answer. The QVW file is attached.

Regards

Re: Comparing selected data with previous data

kaushiknsolanki — Tue, 12 Mar 2013 09:36:48 GMT

HI,

Its right. This expression will be for one month selection only.

what you exactly want to do, will you please describe with example.

Regards,

Kaushik Solanki

Re: Comparing selected data with previous data

Tue, 12 Mar 2013 09:49:47 GMT

I want to find the percentage increase in Sales. So if the user selects Feb then it should display the percantage growth of sales over Jan (this can be done with the expression you provided).

However the user will also be selecting multiple months. Lets say Apr, May and June. In this case i want to see Sales of Jan, Feb and Mar so i can find out the percentage growth of sales.

Re: Comparing selected data with previous data

Gysbert_Wassenaar — Tue, 12 Mar 2013 10:52:51 GMT

You can try using the above function. This has one disadvantage: the first selected month can't be compared with the previous one. If you need that you'll have to create an 'AsOf' table. See attached qvw for both options.

Re: Comparing selected data with previous data

Tue, 12 Mar 2013 12:01:47 GMT

Thanks. You guys have somewhat answered the question but it still doesnt work with multiple selections. But ill try to make this work