I want select max two values in qlikview.

[Srinivas]

Hi All,

In list box i want select max two values only, Not more than two values in list box how can we resolve this issue.

See below screen shot for your reference

Could you please help on this.

Regards,

Munna

[amit_saini]

Munna,

Like this????

Thanks,
AS

[alexandros17]

in the fields list of list box there is an item "expression", select it and write

=If(field <> max(TOTAL field,1) and aaa <> max(TOTAL field,2), null(), field)

let me know

[Srinivas]

In list box by selection time we should select only two values. not like that ..

[Srinivas]

Hi Alessandro,

I couldn't do can you sen any sample application that would be better.

Advance Thanks

Munna

[#6]

Hi Munna Reddy,

You can do it in the scripting sie.

if list box  A have the values 10,20,30,40.....

Load

A,

max(A), Max(A)-1 as MaxMinA

from....

In layout(UI) you can take MaxMinA.

Hope this helps

[tresesco · Accepted solution]

Check attached sample. Used a trigger.

[alexandros17]

Here it is ...