3 Replies Latest reply: Mar 20, 2017 2:47 AM by Anil Babu Samineni RSS

    if else function

    Rolf Dastan

      I have 1 table for companies, 1 table for payments periods, and I have text box containing total amount of payment per period as below:

       

      Untitled.png

      so if i select  client which is pays monthly, QlikSense should view only monthly payment. and hide other periods.

      for example:

      if(payment = 'Quarterly'), ([total device] * [price per unit] * 3)