Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
vanderson009
Creator III
Creator III

Set Analysis

I have below data and i want to display customer name those having Sales for max year as well as previous year.

 

YearCustomerSales
2018A10
2018B20
2017A30
2016C40
20016C10

Regards,

Villyee

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum({<Customer = p({<Year = {$(=Max(Year))}>})*p({<Year = {$(=Max(Year)-1)}>})>}Sales)

View solution in original post

2 Replies
sunny_talwar

May be this

Sum({<Customer = p({<Year = {$(=Max(Year))}>})*p({<Year = {$(=Max(Year)-1)}>})>}Sales)

View solution in original post

vanderson009
Creator III
Creator III
Author

your gr8 stalwar1