Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a scenario in which i have to show top N Customers in a Straight table where
income for Previous Financial Year Last month > ( income current years income /no of months of current year till today),
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.
can you attach a sample excel sheet to make a scenario or a sample qvw. please use sample data like
Please find the attached sample data and the report structure.