Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I wanted to know how to add current and previuos year selection in Qlikview . Can anybody help me .
Thanks and Regard
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)
1. Current Year
Sum({$<Year={$(=Max(Year))}>} Sales)
2. Previous Year
Sum({$<Year={$(=Max(Year)-1)}>} Sales)
Hi,
for this you have to use set analysis.
Why don't you have a look at this document to start with.
Regards
ASHFAQ
hi,
You can Refer the below Link.
QlikView App: Set Analysis - Prior Period Comparison
BR,
Nikitha Jain M.B