topic Re: Expression to display table column values in text boxes? in QlikView

Expression to display table column values in text boxes?

rakesh_kumar — Tue, 19 May 2015 15:01:22 GMT

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,

Re: Expression to display table column values in text boxes?

Anonymous — Tue, 19 May 2015 15:06:00 GMT

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)

Re: Expression to display table column values in text boxes?

rakesh_kumar — Tue, 19 May 2015 15:29:48 GMT

Thanks Mike that solved the problem.