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.