Is it possible to click on any cell in a table in Qlik Sense to automatically set filters from that cell in the general filters?

[Dmitryromanov23]

Good afternoon! I have a table on the first sheet of the application. On the second sheet is inserted a table with calculations. The dimension is the 'process' field, and the measurement is: the sum of the 'process' records by 'area', where 'justified' = 'yes'. How do I make it so that when I click on a cell in the table on page 2, only the records that are counted in that cell come out on the first sheet? The only clickable field is the 'process' field

[vinieme12]

add the measure as a calculated dimension instead

=Aggr(  YourMeasure , process,area)

[Dmitryromanov23]

Hi, Vinieme. Could you send qvf file, please. I didn't get it 

[vinieme12 · Accepted solution]

unfortunately im unable to open your qvf, but the idea to resolve your requirement remains the same

instead of adding measures add dimensions

example if your chart has below measures and dimensions

Dimension:

Process

Area

Measure

=count({<justified={'yes'}>}Process)

remove the measure and it as a dimension, such that 

Dimension:

Process

Area

= AGGR (count({<justified={'yes'}>}Process) , Process,Area)

Add above as Dimension Not Measure

Measures:

<no measures>

replace count({<justified={'yes'}>}Process) with your actual measures used