sum + case

[fmazzarelli]

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)

[jagan]

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.

[jagan]

Hi,

If you got the answer please close this thread by giving Correct Answer to the useful post.

Regards,

Jagan.