Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
chrismtb
Creator
Creator

display one data value in text box based on a lookup

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

1 Solution

Accepted Solutions
MarcoWedel

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

 

hope this helps

Marco

View solution in original post

1 Reply
MarcoWedel

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

 

hope this helps

Marco