topic Re: Max Function in QlikView

Max Function

Wed, 15 Oct 2014 12:46:11 GMT

Hello Friends

Using the below value I am trying to create a pivot table top in each subject and score.

I tried the max function =Max(Score) in the expression and Class in the dimension its fine but when I add Name in the dimension the chart showing the wrong result.

Could you please advise me, how to implement this in a pivot table.

LOAD * Inline [

Class, Name, Score

English, James,5

English, Sneha,6

English, Ram,10

Maths,Troy,1

Maths,Khan,5

Maths,Alif,8

Maths,James,9

Science,Sneha,5

Science,Ram,7

History,Ram,9

History,Khan,3

History,Troy,1

History,James,2

];

Regards

Joe

Re: Max Function

anbu1984 — Wed, 15 Oct 2014 12:50:23 GMT

=Aggr(Max(Score) ,Class)

Re: Max Function

Wed, 15 Oct 2014 12:53:08 GMT

in the expression write : AGGR(Max(Score),Class)

dimension : Name

Re: Max Function

tresB — Wed, 15 Oct 2014 12:53:20 GMT

Dimension: Class

Exp1: FirstSortedValue(Name, -Score)

Exp2: Max(Score)

Re: Max Function

martinpohl — Wed, 15 Oct 2014 12:54:32 GMT

use

max(total <Class> Score)

Regards

Re: Max Function

Wed, 15 Oct 2014 12:55:37 GMT

Hi Anbu,

Thanks for u r reply but the result is wrong for instance Ram is the topper in English but as per your result James.

Regards

Joe

Re: Max Function

Wed, 15 Oct 2014 13:03:38 GMT

Hello All,

thanks a lot for your suggestions,

tresesco, your answer is worked,

Thanks again