Solved: Year comparison - Qlik Community - 670233

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

Hi guys!

I would like to compare the results from the months of the selected year with the previous year.

Is this possible?

I added some more information in the attached document.

Kind regards,

Katleen

Het bericht is bewerkt door: Katleen Vercauteren

213 KB

1 Solution

Accepted Solutions

Hi,

Try below

Current Year Sales

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

Previous Year Sales

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

Regards

ASHFAQ

View solution in original post

3 Replies

Hi,

There is no document attached. Kindly attach again, also give some example of your problem.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Hi,

Try below

Current Year Sales

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

Previous Year Sales

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

Regards

ASHFAQ

Author

Thanks Ashfaq, you've been a great help!