topic Filter field list <= than a variable in QlikView

Filter field list <= than a variable

Wed, 09 Jan 2013 13:07:04 GMT

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

Re: Filter field list <= than a variable

Gysbert_Wassenaar — Wed, 09 Jan 2013 13:15:57 GMT

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

Re: Filter field list <= than a variable

Wed, 09 Jan 2013 15:52:54 GMT

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.