topic Re: Top 10 in an Expression in QlikView

Top 10 in an Expression

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

Hallo all together,

I want to see the top 10 (Costumers) in total Volume. I want to integrated as an example in this expression (=sum ({$<Jahr={2017}>}[_LE_MainVolume]))

I tried to make a set analysis for this expression just to add choosing the top 10 main volume of the customer in 2017..... Can you help People ?

Thanks

vishsaggi — Wed, 08 Aug 2018 16:12:03 GMT

May be this?

= sum ({$< Jahr={2017}, [_LE_MainVolume] = {"=Rank(Sum(_LE_MainVolume),4) <11"} >} [_LE_MainVolume])

sunny_talwar — Wed, 08 Aug 2018 16:17:02 GMT

I think it should be this

=Sum({$<Jahr = {2017}, Costumers = {"=Rank(Sum(_LE_MainVolume),4) <11"}>} [_LE_MainVolume])

mohfaraj — Thu, 09 Aug 2018 06:28:46 GMT

this was correct thanks. One question, for stands the (4) in the equation

mohfaraj — Thu, 09 Aug 2018 06:42:20 GMT

for what *