Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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