Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter field list <= than a variable

Hi,

I have a field called FECRSA with dates which is used as a filter list. I also have a pivot table which change according to the date selected in FECRSA. I would like to filter the pivot table with all the dates <= than the selected FECRSA. I suppose I have to need a variable and some way write in the filter list let FECRSA<=variable. How to get this?

Thanks

2 Replies
Gysbert_Wassenaar

Add a Select in Field action to the OnInput trigger of the variable. Use FECRSA as field and as search string ='<=' & variablenamehere

edit: see attached updated qvw


talk is cheap, supply exceeds demand
Not applicable
Author

I'm sorry but I don't understand, I attached a file.

So far, I'm trying to filter the main pivot table by the field 'FECRSA' being FECRSA<=CORTE. Being CORTE a variable choosed with an input box object.