topic Re: Set Analysis,Aggr,Rank Help in QlikView

Set Analysis,Aggr,Rank Help

Surya — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Analysis,Aggr,Rank Help

tresB — Fri, 29 Nov 2019 13:40:47 GMT

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...

Re: Set Analysis,Aggr,Rank Help

Surya — Sat, 30 Nov 2019 04:05:09 GMT

Thank You so Much