Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CHURN REPORT

Dear All,

I have a scenario in which i have to show top N Customers  in a Straight table where

if

income for Previous Financial Year Last month  > ( income  current years income /no of months of current year till today),

then

show Churn/Loss Amount= Previous Financial Year Last month -  ( income  current years income /no of months of current year)

The above thing is done.

Now i want to get the remaining customers churn amount which are not in TOP N .

Also i want to get the remaining customers amount who have not faced loss.

Please suggest me some solution.

2 Replies
gaurav2017
Creator II
Creator II

Hi,

can you attach a sample excel sheet to make a scenario or a sample qvw. please use sample data like

Employee          Income    

abc                    500$

xyz                    1000$

Regards,

Not applicable
Author

Hi,

Please find the attached sample data and  the report structure.