Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a raw tabel w/t following fields:
- revenues product P1
- revenues product P2
- revenues product P3
- total revenues
I need to:
1 - find top 20% customers (i.e. customers whose revenues are the 20% of Total revenues)
2 - for each product find the average product revenues among top20% customers (let's say AVG_P1, AVG_P2, AVG_P3)
3 - for each customers calculate the difference (revenue product P1 - AVG_P1)
Is there any QLIK function that could be used for that purpose?
Thanks in advance
You can probably use Dimension Limits to show the top 20% revenue customers.
I'm not sure what you're trying to calculate with questions 2 and 3. Can you post a qlikview document that explains those?