topic How to show highest total as KPI? in QlikView

How to show highest total as KPI?

Wed, 19 Feb 2014 12:58:59 GMT

Hi,

I have Students as dimension and their marks total as expression.

Dimension: Students

expression: Sum(Marks)

I would need to show the KPI of which student has highest total. Please let me know is this possible?

I used below. Is this correct expression?

If(Total>0,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

MK_QSL — Wed, 19 Feb 2014 13:00:29 GMT

Please upload your sample file ...

Wed, 19 Feb 2014 13:10:18 GMT

Please find attached.

MK_QSL — Wed, 19 Feb 2014 13:15:18 GMT

Change your KPI expressions as below..

If(Rank(Aggr(SUM(Marks),Student))= 1,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

Wed, 19 Feb 2014 13:15:59 GMT

Hi Amelia

To return the maximum total marks by student, within the table you could use the expression

max(total aggr(sum(Marks),Student))

I've wrapped the sum(Marks) in an Aggr function by student, using the total to work it out across the whole table.

Putting this expression in an if statement and comparing with their marks would enable you to mark out the student with the greatest mark:

if( max(total aggr(sum(Marks),Student)) = sum(Marks),'Highest Student','Not highest student')

Erica

Wed, 19 Feb 2014 13:16:08 GMT

Hi Amelia,

here is my Suggestion for your expression:

if(Rank(Sum(Marks)) = 1 ,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

Regards

Roland

Wed, 19 Feb 2014 13:26:15 GMT

Thanks and that's right.