Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Set Analysis,Aggr,Rank Help

Need Help to write an expression

I get using dimension limits largest 10 Customers in expression i taken max (year) sales

now i have top 10 customers in 2019

same customers performance in 2018 so i want 

same customer Sales of 2017 and 2018

 

for example 2019 top 5

surya

prakash

talwar

vinayk

ravi..

 

i need same person sales in 2017 and 2018

 

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Try using p(), something like:

 

Sum({<[Order Year]={2017,2018},[Customer Name]=p({<[Customer Name]={"=Rank(Sum({<[Order Year]={2019}>}Sales))<=5"}>})>}Sales)

 

You might have to tweak the expression a bit according to your exact requirement, like dynamic year calculation in set rather than hard coding them...

View solution in original post

2 Replies
Highlighted
MVP
MVP

Try using p(), something like:

 

Sum({<[Order Year]={2017,2018},[Customer Name]=p({<[Customer Name]={"=Rank(Sum({<[Order Year]={2019}>}Sales))<=5"}>})>}Sales)

 

You might have to tweak the expression a bit according to your exact requirement, like dynamic year calculation in set rather than hard coding them...

View solution in original post

Highlighted
Creator II
Creator II

Thank You so Much