topic Re: Fetch values of corresponding fields of selected row in App Development

Fetch values of corresponding fields of selected row

VaishnaviMogal213 — Mon, 13 Jan 2025 09:25:08 GMT

Hi,

please refer below data.

Vin	Session
v1	1
v2	2
v2	3
v1	2

there are tow columns in table as Vin and session. I want to achieve the use case like if user selects session 2 from 4th row then vin v1 should be shown. if select 2 from 2nd row then vin v2 should be shown(eg just for understanding row no is not fixed here user can select any session). basically the corresponding vin should be display of selected session row.

How to achieve this in Qlik sense, by default qlik sense gives all associated values from field(eg if i select session 2 then, it gives vin as v2 and v1).

how can i get single corresponding row value?

Thanks!

Re: Fetch values of corresponding fields of selected row

EmmaMcAlister — Mon, 13 Jan 2025 11:19:37 GMT

Hi @VaishnaviMogal213 ,

Would it suit to add a row number or other dimensional reference into your dataset?

LOAD * INLINE [ Vin, Session, Row v1, 1, 1 v2, 2, 2 v2, 3, 3 v1, 2, 4 ];

Then you could use that to make a selection on your dashboard, or use in other expressions.

Or you could combine both dimension fields into one within your final table which would allow you to select both together with a single click.

Re: Fetch values of corresponding fields of selected row

Bhushan_Mahajan — Mon, 13 Jan 2025 12:45:21 GMT

@EmmaMcAlister We can also use Rowno() function to provide identity to each row in Input data.

Re: Fetch values of corresponding fields of selected row

VaishnaviMogal213 — Mon, 13 Jan 2025 18:06:01 GMT

Hi @EmmaMcAlister , Thanks for the reply!

The second approach looks good here!. Just want to confirm that it is not a in built feature in Qlik sense to get corresponding row values after selecting a single value from that row, which is by default possible in other tools like QuickSight.?

Thanks!!

Re: Fetch values of corresponding fields of selected row

VaishnaviMogal213 — Mon, 13 Jan 2025 18:09:47 GMT

@Bhushan_Mahajan , Thanks for the reply!

Could you please elaborate your statement. Do I need to make selection in rowno fields. to get values, or is it possible to fetch values by selecting session after using your logic here?

Thanks!!

Re: Fetch values of corresponding fields of selected row

Bhushan_Mahajan — Tue, 14 Jan 2025 05:29:15 GMT

@VaishnaviMogal213 Yes Vaishnavi definitely you need to select the the rowno so that you will get relevant value of session corresponding to that selection. Please use that RowNo() function in Script not in chart.

Re: Fetch values of corresponding fields of selected row

EmmaMcAlister — Mon, 20 Jan 2025 08:46:03 GMT

@VaishnaviMogal213

Selecting a value in a dimensional row of your table will filter your dataset by that value, so selecting Session 2 will show you the data relating to Session 2, not relating to the row of your front end table. I think the concatenated field will work nicely for you. It's good to understand what's happening in the background when you make selections.