display one data value in text box based on a lookup

chrismtb — Mon, 01 Nov 2021 09:56:54 GMT

Hi all,

I have an issue which I could do with some help on.

I have a data set (simplified below) that i have loaded into my application:

ID	Area	Manager	Status
1	Northwest	Jenny	Active
2	Northeast	Steve	Closed
3	Southwest	Mike	Active
4	Southeast	Carol	Closed

I want to create a set of text boxes for a report that pull this data out individually i.e. a text box that will display the Area for the ID 1 and another when the ID is 2, so in effect using a lookup type function.

i thought of using an if statement... if(ID=1, Area, ' ') however this only works for me if just the one data line is filtered in the application.

Can anyone help me with this?

Thanks

Chris

Re: display one data value in text box based on a lookup

MarcoWedel — Mon, 01 Nov 2021 21:01:15 GMT

=Only({$<ID={1}>} Area)

hope this helps

Marco

topic Re: display one data value in text box based on a lookup in QlikView

display one data value in text box based on a lookup

Re: display one data value in text box based on a lookup