topic Re: Simple If condition in set analysis in QlikView

Simple If condition in set analysis

Anonymous — Wed, 06 Feb 2013 17:09:16 GMT

Hi All,

I am trying use below expression to derive sales for different vehicles:

IF(vSelectedVehicle = 'MF','SUM({<vehicle={'MFV}>}sales')','SUM({<vehicle={'MAV'}>}sales)').

It is not computing the value. QVW has been attached

Thanks

Dasu.G

alexandros17 — Wed, 06 Feb 2013 17:13:21 GMT

this is the correct expression

=IF(vSelectedVehicle = 'MF',SUM({<vehicle={'MFV'}>}sales),SUM({<vehicle={'MAV'}>}sales))

jagan — Wed, 06 Feb 2013 19:51:46 GMT

Hi,

Please find attached file for solution, for Actions -> Set Variable -> MF/MA

You should not give 'MF' or 'MA' with single quotes.

Hope this helps you.

Regards,

Jagan.