Exclude Max value product using script

[Shubham_Deshmukh]

Hi Qlikers,

It is quite simple but m getting confuse for this in scripts. I want to exclude max value product (D) from my list to show in straight table, I am extracting below data from excel sheet.

PRODUCT	Value
A	10
C	20
D	30
E	40
E	50
D	90

Expected output   :

PRODUCT	Value
A	10
C	20
E	40
E	50

Thanks

[tresesco]

Subham, 

That is pretty obvious. You are doing a basic mistake. E has two values and when you use '=Value' expression it would not be able to two values, you should rather use Sum(Value) as expression.

You might want to Like and close the thread. 

[Shubham_Deshmukh]

@tresesco , I tried it before also still shows the same.

[jyothish8807]

There seems to be an "if" condition on your dimension, can try removing it and check ? The solution from @tresesco  should work

[Shubham_Deshmukh]

@jyothish8807 , Ya my mistake, Sorry.

Thanks @tresesco , your solution working fine.

THanks @jyothish8807 .