topic Re: Part of total in QlikView

Part of total

Fri, 04 Jul 2014 11:16:35 GMT

I've the following data.

Shop	Customer	Total Sales	Total Cost	Total Profit
10	AAA	10000	5000	5000
10	BBB	60000	20000	40000
10	CCC	15000	10000	5000
30	DDD	60000	40000	20000
30	EEE	800000	700000	100000
40	FFF	4500	500	4000
40	GGG	1000	50	950
20	HHH	3000	2500	500
20	III	25000	22000	3000
10	JJJ	8500	8000	500

Now i want to group per store total number of customers

Numbers of customers that stands for 90% of the sales per store

Numbers of customers that stands for 80% of the profit per store

mahesh_agrawal — Fri, 04 Jul 2014 11:57:29 GMT

Hi,

Please find the attached QVW file.

Gysbert_Wassenaar — Fri, 04 Jul 2014 12:01:14 GMT

See attached qvw. If you want to do this with chart expressions only... good luck. I'm not even going to try.