1 Reply Latest reply: Jun 19, 2018 7:32 AM by Sunny Talwar RSS

    if else qlikview expression

    Prabu Nakil

      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.