Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 

if then else statement on Qlik sense

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.



0 Replies