topic Re: Scenario to display sales data in between years using set analysis. in QlikView

Scenario to display sales data in between years using set analysis.

Sat, 10 Oct 2015 17:29:34 GMT

Recently I attended an interview. Below is one of the questions asked. Could any one please help me with the answer.

Suppose we have sales data for years from 2001 to 2015. If I select year 2015, the chart should display sales data for years 2010 to 2015. Similarly, If I select year 2010, the chart should display sales data for years 2005 to 2010.

How can you do that using set analysis ?

Re: Scenario to display sales data in between years using set analysis.

maxgro — Sat, 10 Oct 2015 17:36:42 GMT

you ca use a chart with year as dimension and this expression

sum({$ <year={">=$(=max(year)-5)<=$(=max(year))"}> } sales)

Re: Scenario to display sales data in between years using set analysis.

Sat, 10 Oct 2015 17:53:14 GMT

Thanks Maxgro.

I believe max(year) is identical to year. Please correct me if I am wrong.

Do you think the above expression gives correct results if I select year as 2010 ?

Thanks,

Chowdary

Re: Scenario to display sales data in between years using set analysis.

maxgro — Sat, 10 Oct 2015 18:09:25 GMT

small example in the attachment

Re: Scenario to display sales data in between years using set analysis.

Mon, 12 Oct 2015 10:52:56 GMT

Thanks maxgro.

It works

Re: Scenario to display sales data in between years using set analysis.

maxgro — Mon, 12 Oct 2015 17:32:56 GMT

please close the thread