topic Wanted to get previous year data by clicking one button in QlikView

Wanted to get previous year data by clicking one button

Tue, 06 May 2014 10:30:06 GMT

Can ayone please tell me how to achive below one:

I wanted to create a button with the name "Previous Year", when you click on that button the entire dashboard should shows only previous year data.

Please help, Thanks in Advance

ashfaq_haseeb — Tue, 06 May 2014 10:37:01 GMT

Hi,

May be like this.

Regards

ASHFAQ

Tue, 06 May 2014 10:39:07 GMT

Thanks Ashfaq for the reply

Can you please send me the process in reply only if possible, since i am using desktap version of QV, i can not open this file

ashfaq_haseeb — Tue, 06 May 2014 10:42:51 GMT

Create a button.

and add trigger Select in field

and Select field Year assuming you have year and write the below expression.

=year(today())-1

Please find the snapshot attached.

Hope it helped.

Regards

ASHFAQ

Wed, 07 May 2014 04:49:32 GMT

It did not help, sorry

Actualy i created two chart having three years of the data, my requirement is

if you are showing 2014 data in one chart, by clicking previous year button the second chart should show previous year data.

Thank you so much Ashfaq

Wed, 07 May 2014 05:14:37 GMT

Try to use set analysis

In the first diagrams display the current year. expression should be something like:

sum ({DimensionYear = {$ (=Year(Today()))}} Value)

The second diagram shows the previous year. Expression:

sum ({DimensionYear = {$ (=Year (Today()) -1)}} Value)

DimensionYear - the name of the field that contains year in the data model

It will work without buttons. Use Previous year button you can show/hide the second diagram.