Expression to display table column values in text boxes?

[rakesh_kumar]

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.

Thanks,

RK

[Anonymous · Accepted solution]

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]

Thanks Mike that solved the problem.