Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rakesh_kumar
Creator
Creator

Expression to display table column values in text boxes?

Hi Qlik Stars,

I needed an expression to display column values in a table (Table in the data model, not front end tables) into text boxes as shown in the below screenshot, how can I do that?

Note: I created the straight table just for demonstration purposes, but it is a table in the data model.

Screenshot.png

Thanks,

RK

1 Solution

Accepted Solutions
Anonymous
Not applicable

If the number of rows is fixed, e.g. 7, create seven text boxes with expressions:

FirstSortedValue(Patient_Count, Bed_wait_Date, 1)

FirstSortedValue(Patient_Count, Bed_wait_Date, 2)

...

FirstSortedValue(Patient_Count, Bed_wait_Date, 7)

View solution in original post

2 Replies
Anonymous
Not applicable

If the number of rows is fixed, e.g. 7, create seven text boxes with expressions:

FirstSortedValue(Patient_Count, Bed_wait_Date, 1)

FirstSortedValue(Patient_Count, Bed_wait_Date, 2)

...

FirstSortedValue(Patient_Count, Bed_wait_Date, 7)

rakesh_kumar
Creator
Creator
Author

Thanks Mike that solved the problem.