Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I would make the sum of two fields conditioned by another value
example :
case white
sum(1+10):
case red
sum(2+20)
else
sum(3+20)
Hi,
Try like this
Pick(WildMatch(FieldName, 'white', 'red', '*'),
Sum({<field -= {'VALUE'}>}),
Sum({<field -= {'VALUE'}>}),
Sum({<field -= {'VALUE'}>}))
Qlikview compiler will show the above expression as error but it works, because -= it will show error.
Hope this helps you.
Regards,
Jagan.
Hi,
If you got the answer please close this thread by giving Correct Answer to the useful post.
Regards,
Jagan.