Retrieve values of a column A for a row selected on a table regardless of the column selected on this row and use these values to filter another sheet

[Thathayoyo]

Hello,

I am new to Qlik. To summarize I have a table on a sheet 1 including a column A which contains a list of indices. We use the index list from column A to then filter the entries of another table on a sheet 2 (a button allows you to navigate to the sheet once for a row, the value of column A has been selected).

I would like to ensure that on sheet 1, for a given row of the table, regardless of the column that the user selected, values of column A are always selected. These values are stored and then find a way to use this stored values to filter my table on my sheet 2.

Thanks in advance.

[KJM]

Hi Thathayoyo

Could you upload a screenshot or preferably a sample app - struggling to visualise the query 🙂

K.

[Thathayoyo]

For the moment it's just theory, I made a quick schema to explain better.

On a sheet 1 I have a table from which I use values ​​included in column "A" in order to filter a table on a sheet 2 (On the table from the sheet 2, I only keep the rows from the table  which for a colum "name" included values in common with the ones from column "A" from my last table).

We are thinking of using a GetFieldSelections on column A and then filter. My problem is the user need to click on column A with this method (see the green box in the schema). What we are trying to do is that no matter which column is selected on the line (see the green arrow), values from the column "A" are automatically selected (green box).  How can we do it?

Also after we have retrieved values from colum "A" , we dont know how to keep it in order to use it in the sheet 2 and also how to use it to filter the table on sheet 2.

Thanks.