Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Contributor II

Re: CHURN REPORT

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

Re: CHURN REPORT

Hi,

Please find the attached sample data and  the report structure.

Community Browser