topic Re: Conditional Show corresponding to field value in related table in QlikView

Conditional Show corresponding to field value in related table

Sat, 22 Nov 2014 22:21:13 GMT

On a list box I only want to show the Field values that have another field value associated to them.

Table A		Table B
ID	Name	Name	Input
1	A	A	Yes
2	B	B	No
3	C	C
4	D	D

For Example from the above tables I create a list box in a Sheet with ID and Name, I only want it to display those IDs that have a value in Input field in table B

Re: Conditional Show corresponding to field value in related table

Sat, 22 Nov 2014 23:04:42 GMT

write an expression in the list box instead of column . Assuming that Table A and B are associated with Name column.

if(len(input)>0, ID)

Re: Conditional Show corresponding to field value in related table

afurtado — Sat, 22 Nov 2014 23:19:41 GMT

like Eddie Morah but other expression

=if(Input <> '',ID)

Best,

Alessandro Furtado

Re: Conditional Show corresponding to field value in related table

afurtado — Sat, 22 Nov 2014 23:22:31 GMT

but thinking better it depends about your data. Like Eddie Morah will works everytime (using len).....

Alessandro Furtado

Re: Conditional Show corresponding to field value in related table

Mon, 24 Nov 2014 17:31:47 GMT

Thanks guys was very helpful