else part in set analysis

Wed, 27 Mar 2013 06:47:29 GMT

Dear all ,

i want to convert this one to set analysis

Please Post the Relative answer

SUM

(if(PRODUCTCODE='APG' or PRODUCTCODE='CAS' or

PRODUCTCODE='EAL' OR
PRODUCTCODE='EAR' OR
PRODUCTCODE='EBI' OR
PRODUCTCODE='EBP' OR
PRODUCTCODE='ECR' OR
PRODUCTCODE='EEI' OR
PRODUCTCODE='EMB' OR
PRODUCTCODE='EMC' OR
PRODUCTCODE='EPM' OR
PRODUCTCODE='FAL' OR
PRODUCTCODE='FBI' OR
PRODUCTCODE='FCSH' OR
PRODUCTCODE='FISE' OR
PRODUCTCODE='FMD' OR
PRODUCTCODE='FPP' OR
PRODUCTCODE='FTFT' OR
PRODUCTCODE='IAR' OR
PRODUCTCODE='LPA' OR
PRODUCTCODE='LPD' OR
PRODUCTCODE='LWC' OR
PRODUCTCODE='MCG' OR
PRODUCTCODE='PPL' OR
PRODUCTCODE='SCN' OR
PRODUCTCODE='SFG' ,RICOMM,RIWP_OD

*0.1))

Re: else part in set analysis

CELAMBARASAN — Wed, 27 Mar 2013 06:56:27 GMT

Try this

Sum({<PRODUCTCODE={'APG','CAS','EAL',''EAR'}>} RICOMM,RIWP_OD*0.1)

Add as much as you want in the Productcode.

But better keep this in a variable instead of hardcoding

Sum({<PRODUCTCODE={$(vProductCodes)}>} RICOMM,RIWP_OD*0.1)

topic else part in set analysis in QlikView

else part in set analysis

Re: else part in set analysis