if then else statement on Qlik sense

Anonymous — Thu, 30 Aug 2018 09:32:44 GMT

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.

topic if then else statement on Qlik sense in App Development

if then else statement on Qlik sense