Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Top 10 in an Expression

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

Mo

1 Solution

Accepted Solutions
Highlighted

I think it should be this

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

View solution in original post

4 Replies
Highlighted
Champion III
Champion III

May be this?


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

Highlighted

I think it should be this

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

View solution in original post

Highlighted
Contributor II
Contributor II

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

Highlighted
Contributor II
Contributor II

for what *