Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Can anyone tell me how can i do a year to year , month to month analysis
Hi,
In that case below expressions must work.
Current Year Sales
=Sum({<Year = {'$(=Max(Year))'}>} Sales)
Previous Year Sales
=Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)
Modify them accordingly
Regards
ASHFAQ
Have a look here: Year Over Year Comparison
i wanted to know how show last year and current year variance in qlikiview
Hi,
In that case below expressions must work.
Current Year Sales
=Sum({<Year = {'$(=Max(Year))'}>} Sales)
Previous Year Sales
=Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)
Modify them accordingly
Regards
ASHFAQ