topic Re: QV - Chart Top 10 evolution (positive & negative) in QlikView

QV - Chart Top 10 evolution (positive & negative)

stephane_kosior — Thu, 11 Jan 2018 10:43:58 GMT

Hi,

I would like to create a chart showing the top 10 evolution (positive & negative) by customers.

Here it is the Top 10 positive but how to include the negative value in the same chart ?

Many thanks

Anil_Babu_Samineni — Thu, 11 Jan 2018 10:58:00 GMT

Possible, Let me know how can we help you?

stephane_kosior — Thu, 11 Jan 2018 11:01:39 GMT

Many thanks for your answer but is there any chance you can provide some explanations ?

Anil_Babu_Samineni — Thu, 11 Jan 2018 11:12:29 GMT

Here are the approaches, I usually followed in measure

+ve -- SUM({<Name = {"=Rank(SUM(Amount))<=10"}>}Amount)

-ve -- SUM({<Name = {"=Rank(-SUM(Amount))<=10"}>}Amount)

Dimension level, It would be this?

+ve -- If(Aggr(Rank(SUM(Amount)), Name)<=10, Name)

-ve -- If(Aggr(Rank(-SUM(Amount)), Name)<=10, Name)