Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

prabunakil
New Contributor

if else qlikview expression

I want to write a if else sum qlikview expression in pivot table. Please advise. my concept is as per below:

IF [Bill Type] = {'S1'}. [KSCHL]={'Z1PR'}

     then SUM ([KONV_KWERT]*-1)

ELSE [Bill Type] = {'ZLG2'}. [KSCHL]={'Z1PR'}

     then SUM ([KONV_KWERT]*-1)


ELSE [Bill Type] = {'ZLRE'}. [KSCHL]={'Z1PR'}

     then SUM ([KONV_KWERT]*0)


Please advise the correct statement.

1 Reply

Re: if else qlikview expression

Is the last condition just 0? Sum([KONV_KWERT]*0)... Anything multiplied with 0, will be 0, right? Also, the first two conditions look the same... may be you just need this

Sum({<[Bill Type] = {'S1', 'ZLG2'}, [KSCHL]={'Z1PR'}>}[KONV_KWERT]*-1)

Community Browser