Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Mastering Change Data Capture: Read Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a Top/Bottom 5 list, with smileys

Hi

I'm trying to create a list with both top 5 and bottom 5, it works fine with this code in expressions:

=if(rank(sum(Fortjeneste),4)<=5 or rank(-sum(Fortjeneste),4)<=5, sum(Fortjeneste),0)

But when I add a column with smileys, I lose some of the function from the code above, it now starts to return all sellers in that group, but the value from 'Fortjeneste' is 0 for all except from the top/bottom 5.

Smileys code in expressions:

if(sum(Fortjeneste)>600000,'qmem://<bundled>/BuiltIn/smiley1_g.png',

if(sum(Fortjeneste)>400001,'qmem://<bundled>/BuiltIn/smiley2.png',

if(sum(Fortjeneste)<400000,'qmem://<bundled>/BuiltIn/smiley3_r.png')))

Why does this code affect the if(rank((sum...... code?

Kind regards

Espen

0 Replies