topic Re: Show all data with filter in QlikView

Show all data with filter

Tue, 18 Jun 2013 21:06:48 GMT

I have two tables. I need to click in table B and not filter the table records A. But when I click on the table A I need to filter the fields of the table b.

Table A				Table B
product	type a	qtd a	value b	product	type b	qtd b	value b
1	AA	10	10	1	XX	5	40
2	BB	2	20	8	YY	4	50
3	BB	3	30	3	WW	2	30
4	CC	4	40	5	WW	3	70

For example, click in B type WW, this is result;

Table A				Table B
product	type a	qtd a	value b	product	type b	qtd b	value b
1	AA	10	10	3	WW	2	30
2	BB	2	20	4	WW	3	70
3	BB	3	30
4	CC	4	40

when click in A type AA, this is result;

Table A				Table B
product	type a	qtd a	value b	product	type b	qtd b	value b
1	AA	10	10	1	XX	5	40

thanks.

Re: Show all data with filter

sujeetsingh — Wed, 19 Jun 2013 03:32:29 GMT

Hi,

See you cant create this functionality just by using Alternate state .

Here you can have two B tables in which one will have no selection associtaion well the other will have

Re: Show all data with filter

sujeetsingh — Wed, 19 Jun 2013 03:37:29 GMT

Silva can you post a sample

Re: Show all data with filter

Wed, 19 Jun 2013 18:06:42 GMT

Hi Tiger,

When I click on the type WW is right, but when I click on the AA I wish that filtered products in both tables. Showing only the product 1.

sample attached.

Re: Show all data with filter

Thu, 20 Jun 2013 12:04:26 GMT

Hi tiger,

I managed to make it work. following sample...

Thanks,