0 Replies Latest reply: Aug 30, 2018 5:32 AM by Lucas Nkgabutle RSS

    if then else statement on Qlik sense

    Lucas Nkgabutle

      Good day,

       

      I am new to Qlik technology and to this community platform.

       

      I am struggling to answer some questions from Users.

       

      I want to create a view.

       

      This view should answer the following questions based on month as dimension and amount as measure.

       

           1) In the current period (201808), which customers were not billed or amount = 0? for this customers I have to display 'Contract terminated' as a message and a list of these customers.

           2) In the previous period (201807), which customers were not billed or amount = 0 as compared to 201808? for this I have to display a list of customers and 'New Contract' message.

           3) If an amount appears in both 201808 and 201807 and there is a difference then display a list of customers and this message 'Contract amount changed'.


      Not sure how to go about this.


      Your assistance is highly appreciated.


      Regards,

      Lucas.