Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasdnk
Contributor
Contributor

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.


Regards,

Lucas.




0 Replies