Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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!! 

View solution in original post