Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

This Year vs Previous Year

I have Year and Sales data.

Now I want if user select any year then table will show selected year and previous year sales.

Please help me. Sample app attached.

2 Replies
Highlighted
Specialist II
Specialist II

Hi Soha,

PFA Hope this will solve your issue.

Current Year = sum({<Year= {'$(=Max(Year))'}>} Sales2)

Previous Year = sum({<Year= {'$(=Max(Year)-1)'}>} Sales2)

-- Regards,

Vishal Waghole

Highlighted
Master II
Master II

Hi

Go here Current Period and Last year Same Period

Hope it helps you