topic Possible Selection in QlikView

Possible Selection

Wed, 10 Oct 2012 10:00:41 GMT

I have two Fields 'Market' and 'Product'.

The table is Like this

Market	Product
A	K
A	L
A	M
A	N
B	P
B	Q
B	R
C	X
C	Y
C	Z

Product K.L,M,N fall under market A, P,Q,R fall under market B and X,Y,Z fall under market C.

Now if i select a Product the corresponding market gets filtered but i want the filtered market to be selected. How can i do that.

I have attached a sample QVW for the same.

Re: Possible Selection

Wed, 10 Oct 2012 11:59:55 GMT

I don't know exactly what you want but if you have for example a field qty then you can use this as expression to sum the quantity on the whole market if you select a product:

sum({1<Market>}qty)

Does this help you a bit?

Re: Possible Selection

Anonymous — Wed, 10 Oct 2012 15:43:42 GMT

Create a trigger on field Product, on event OnSelect (document priperties, triggers). The action should be Selct Possible in field Market.

Regards,

Michael