Cureent Year and Previous Year

[#1]

Hi All,

     I wanted to know how to add current and previuos year selection in Qlikview .  Can anybody help me .

    Thanks and Regard

[satishkurra]

Hi

Please get the Year drop down on to the report and enter below expressions in Expressions Tab of Chart Properties

1. Current Year

Sum({$<Year={$(=Only(Year))}>} Sales)

2. Previous Year

Sum({$<Year={$(=Only(Year)-1)}>} Sales)

[senpradip007]

1. Current Year

Sum({$<Year={$(=Max(Year))}>} Sales)

2. Previous Year

Sum({$<Year={$(=Max(Year)-1)}>} Sales)

[ashfaq_haseeb]

Hi,

for this you have to use set analysis.

Why don't you have a look at this document to start with.

Regards

ASHFAQ

[#5]

hi,

You can Refer  the below Link.

QlikView App: Set Analysis - Prior Period Comparison

BR,

Nikitha Jain M.B