Fetch values of corresponding fields of selected row

[VaishnaviMogal213]

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!

[EmmaMcAlister]

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.

[Bhushan_Mahajan]

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

[VaishnaviMogal213]

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!!

[VaishnaviMogal213]

@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!!

[Bhushan_Mahajan]

@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.

[EmmaMcAlister]

@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.