topic Re: Condtion to set expression in QlikView

Condtion to set expression

koushik_btech20 — Mon, 24 Apr 2017 08:26:03 GMT

Hi All,

I have this below expression which I want to implement by set analysis,

sum(if((SCEN_ID = 0 or SCEN_ID=AD_SCEN_ID) and COMPONENT_ID <> 0 and C_FLAG >= 0, C_QUANTITY))

Thanks

Koushik

koushik_btech20 — Mon, 24 Apr 2017 08:35:22 GMT

I tried below expression but it is not working,

Sum({(<SCEN_ID={0}> + <SCEN_ID=AD_SCEN_ID>) * <COMPONENT_ID ={"<>0"}> * <C_FLAG ={">=0"}>} C_QUANTITY)

prashantbaste — Mon, 24 Apr 2017 08:54:12 GMT

Hi Koushik,

Try below expression -

Sum({<SCEN_ID=P(AD_SCEN_ID,0), COMPONENT_ID ={'*'}-{'0'}, C_FLAG ={'>=0'} >}C_QUANTITY)

Please confirm if above works correct for you by marking Answer as Correct.

Regards,

Prashant P Baste

koushik_btech20 — Mon, 24 Apr 2017 09:14:55 GMT

Its throwing error as error in set modifier P function parameter list

sunny_talwar — Mon, 24 Apr 2017 09:32:33 GMT

May be try this

Sum({<SCEN_ID = P(AD_SCEN_ID), COMPONENT_ID =-{'0'}, C_FLAG ={'>=0'}>+

<SCEN_ID = {0}, COMPONENT_ID =-{'0'}, C_FLAG ={'>=0'}>} C_QUANTITY)