Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
aashisku
Contributor II
Contributor II

Filtering table records dynamically

Hello everyone,

Please can some one help me regarding a visualization of table chart. I have a table  chart and a variable input slider (custom object provided in qlik sense desktop).

 

Problem is that when i move the slider, the records are not filtered out automatically. I think the slider' selection is not updating the table contents.

Please note that i want to put  numeric condition on the field, (say A) . For example, A > value of slider.

 

Thank you.

Aashish Kumar

1 Solution

Accepted Solutions
aashisku
Contributor II
Contributor II
Author

Thank you so much Gavinlaird!! 

View solution in original post

2 Replies
gavinlaird
Contributor III
Contributor III

You must put the filter logic in the expressions of the table in order for the table to be filtered when you input a variable (variables aren't connected to the data structure, so inputting a variable does not affect which records are included in your selection).

Replace your expression for field, "A" in the table with the following, which will return NULL when A < the value of the variable set by your slider.

if(A > vValueOfSlider, A)

 You will also want to make the other fields in that table check if A > vValueOfSlider as well. For example, the column for field, "B" should be changed to:

if(A > vValueOfSlider, B)

 

aashisku
Contributor II
Contributor II
Author

Thank you so much Gavinlaird!!