Creating a Top/Bottom 5 list, with smileys

Fri, 02 May 2014 09:45:44 GMT

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

topic Creating a Top/Bottom 5 list, with smileys in QlikView

Creating a Top/Bottom 5 list, with smileys