Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabunakil
Contributor III
Contributor III

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
sunny_talwar

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)