Year to year analysis

[#1]

Hi All

Can anyone tell me how can i do a year to year , month to month analysis

[MK_QSL]

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd

[tresesco]

Have a look here: Year Over Year Comparison

[ashfaq_haseeb]

Hi,

have  a look at below post.

http://community.qlik.com/docs/DOC-6163

Regards

ASHFAQ

[#5]

i wanted  to know how show last year and current year variance in qlikiview

[ashfaq_haseeb · Accepted solution]

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