topic Re: Netting ... How to collapse / expand in pivot table base on condition in QlikView

Netting ... How to collapse / expand in pivot table base on condition

zarmoton — Thu, 13 Nov 2014 16:51:24 GMT

Hello

Not easy !! please can you help me on this complex (for me !!) problem :

i have the following data

on the simple pivot table we can have

on a simple pivot table we have
	Qty_Net	Price_Net
	sum(way*qty)	sum(wayqtyprice)
A	130	2490
B	0	1000
C	0	0
D	-25	350

and i would like to be able to see:

Zone	id	Qty_Net	Price_Net_avg
A	0	130	19.15	<-- Grouping because Qty_net > 0 and price_net > 0
B	1003	-200	50	<-- No grouping, because qty_net = 0 (see in B20)
B	1004	200	55
C	0	0	0	<-- No detail because Qty_net =0 and Price_net = 0
D	1008	50	25	<-- No grouping, because price_net / qty_net < 0 (350/-25)
D	1009	-75	12

My problem is how to collapse and do sum depending on condition

thank you for your help.

Warm Regards

Thu, 13 Nov 2014 18:46:26 GMT

Laurent,

I usually do this with scripting and setting flags versus complex expressions.

Is this what you are looking for? I have attached sample app with script. Let me know if this helps

zarmoton — Tue, 18 Nov 2014 09:55:54 GMT

First Thank you for your help

Probably very useful

But i don’t see your script ….

Can you attach your qvw ?

thk you again

Regards,

zarmoton — Tue, 18 Nov 2014 09:59:36 GMT

First Thank you for your help

Probably very useful

But i don’t see your script ….

Tue, 18 Nov 2014 17:15:10 GMT

sorry, adding now

zarmoton — Tue, 18 Nov 2014 17:50:43 GMT

Thk yu

Very useful