2 Replies Latest reply: Feb 18, 2016 12:25 PM by Gysbert Wassenaar

# how to write expresion

HI All,Looks a bit simple but not working out for me

let say like this

location   date                     score1         score2    score3       finalscore

czl          01/20/2105               10               10         10                10

czl          02/20/2105               20               20         20                20

czl          03/20/2105               50                50        50                50

first requirement is simple  just show max finalscore with location:

in a straight table i choose location as dimension

expression :max(finalscore)

result:@

location              max(finalscore)

czl                         50      ....... which is fine

second requirement :if end user want to see the max(finalscore) sub values i mean score1 score2 score3 on clicking on location which is in my case

max(finalscore)     score1   score2     score3

50                            10       10              10

to achieve this i wrote crosstable function in  script  like

crosstable(score,values,3)

date,

finalscore,

score1,

score2,

score3

FROM

[C:\qlikview\QVDS\AuditScore.qvd]

(qvd);

in my sheet they will be two charts tables      1.result chart(on clicking  any location which associated with max(finalscore))

2.straight  chart with score1,score2,score3 values of max(finalscore)

second chart:

dimension:location,score(which i got by applying cross function)

location        score        expression has to be written to fetch only those values

czl               score1          50

czl               score2          50

czl               score3          50

finally i need help what expression should i need to write to achieve this please

thanks

naveen

• ###### Re: how to write expresion

Hello

sorry the actual values r

max(finalscore)     score1   score2     score3

50                            50      50             50

thanks

naveen

• ###### Re: how to write expresion

It might actually be easier without the crosstable:

• max(finalscore)
• firstsortedvalue(score1, -finalescore)
• firstsortedvalue(score2, -finalescore)
• firstsortedvalue(score3, -finalescore)

if you use the crosstable function it becomes:

• max(finalscore)
• firstsortedvalue({<score={'score1'}>}values, -finalescore)
• firstsortedvalue({<score={'score2'}>}values, -finalescore)
• firstsortedvalue({<score={'score3'}>}values, -finalescore)