topic Filling columns in a straight table conditionally (Dynamic) in QlikView

Filling columns in a straight table conditionally (Dynamic)

Wed, 17 Nov 2010 09:45:05 GMT

Hi there.

I am having a problem filling columns conditionally in a straight table.

I tried to create a expression that works fine but without luck.

I want to have a value cluster per client. The client can have several products and depending on any combination of filter criteria the sum of the value should be displayed in one of the value clusters.

e.g.

1. Selecting all clients the sum per client should be displayed in the dedicated value cluster.

2. Selecting only one client. Values should be split in the value cluster depended of the sum per product.

I tried to give a simple example below

CLIENT	PRODUCT	VALUE
12345	A	100
56879	A	20
12345	B	50


Sum of all clients
CLIENT	VALUE
CLIENT	>=20 <=50	>=50 <=200
12345	0	150
56879	20	0

Selecting Client 12345
CLIENT	VALUE
CLIENT	>=20 <=50	>=50 <=200
12345	50	100

Thanks

Filling columns in a straight table conditionally (Dynamic)

Wed, 17 Nov 2010 10:38:33 GMT

If I understant you correctly the following post might help.

http://community.qlik.com/forums/t/30286.aspx

Gav.

Filling columns in a straight table conditionally (Dynamic)

Wed, 17 Nov 2010 11:53:58 GMT

Perfect. Exactly what i was looking for.

Thanks Gav.

Re: Filling columns in a straight table conditionally (Dynamic)

Wed, 19 Sep 2012 14:16:11 GMT

Hi Pearceg,

the link you provided seems not working anymore

http://community.qlik.com/forums/t/30286.aspx

Is there a way to retrieve this post ?

Thks

Chris