Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Year to year analysis

Hi All

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

1 Solution

Accepted Solutions
ashfaq_haseeb
Not applicable

Re: Year to year 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

5 Replies
MK_QSL
Not applicable

Re: Year to year analysis

tresesco
Not applicable

Re: Year to year analysis

Have a look here: Year Over Year Comparison

ashfaq_haseeb
Not applicable

Re: Year to year analysis

Hi,

have  a look at below post.

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

Regards

ASHFAQ

Not applicable

Re: Year to year analysis

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

ashfaq_haseeb
Not applicable

Re: Year to year 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