topic Re: Top 10 and Worst 10 in QlikView

Top 10 and Worst 10

dmohanty — Sat, 19 Apr 2014 18:54:27 GMT

Hi All,

I have a table like this below. I need to calculate Actual - Target. If the result is Positive (>0), then I need to show Top 10 CustomerID.

Also, if the result is Negative (<0), then I need to show Bottom 10 CustomerID.

I was able to create an expression till this (using a Single Field). How to show RANK using difference (Actual - Target)?

sum({<CustomerID = {"=Rank(sum(ActualSales))<=10"}>}ActualSales)

Source Table is like this:

Regards!!!

mambi — Sat, 19 Apr 2014 19:39:20 GMT

you can try by adding the minus sign in front of the sum function like this :

sum({<CustomerID = {"=Rank(-sum(ActualSales))<=10"}>}ActualSales)

swuehl — Sat, 19 Apr 2014 21:17:16 GMT

Maybe like this:

=sum(

{<CustomerID = {"=Rank(sum(ActualSales-TargetSales))<=10 or Rank(-sum(ActualSales-TargetSales))<=10"}>} ActualSales-TargetSales)

maxgro — Sat, 19 Apr 2014 22:41:33 GMT

=sum({$

<CustomerID={"=Rank(sum(ActualSales-TargetSales))<=10"}>

<CustomerID={"=Rank(-sum(ActualSales-TargetSales))<=10"}>}

ActualSales-TargetSales )

dmohanty — Sun, 20 Apr 2014 12:13:43 GMT

Thank you very much Swuehl, and thank you others for helping.

This helped correctly. Marking it correct and closing the thread.