Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
eru-alelo
New Contributor

Create Customer Billing Scenarios.

Hello, I am a beginner in Qliv and I need to create Customer Billing scenarios to analyze their monthly performance.

To arrive at the result of items 1, 2 and 3, I have to make an account of the current month about the average billing that will give me a%

= IF (Current Month / Average Fat for> 1.3; "Increased Fat"; IF (Current Month / Fat Mean for> 0.7; "Fat Stable"; "Reduced Fat")))

It's 4 should consider the current month without billing,

It is 5 should consider current month, plus the last 2 months previous, without billing

It is 6 should consider current month, plus the last 4 months previous, without billing

It's 7 should consider current month, plus 1 month before, without billing

Desired Scenes:

1- Stable Billing,

2- Increased Billing,

3- Reduced Billing,

4- No Billing, (current month without billing)

5- Churn 90, (3 months without Billing)

6- Churn> 90, (Over 3 months without Billing)

7- Churn 60, (2 months unbilled)

Tags (2)
Community Browser