Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Dmitryromanov23
Contributor III
Contributor III

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?

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

Labels (5)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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

vinieme12_0-1679904182619.png

 

Measures:

<no measures>

 

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

3 Replies
vinieme12
Champion III
Champion III

add the measure as a calculated dimension instead

 

=Aggr(  YourMeasure , process,area)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Dmitryromanov23
Contributor III
Contributor III
Author

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

vinieme12
Champion III
Champion III

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

vinieme12_0-1679904182619.png

 

Measures:

<no measures>

 

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.