topic Re: Filter table based on two dates in QlikView

Filter table based on two dates

Fri, 05 Dec 2014 15:21:15 GMT

Hi,

I need to filter a table based on two dates which can be selected by the user.

Has someone a solution?

Kind regards

Michael

Re: Filter table based on two dates

giakoum — Fri, 05 Dec 2014 15:29:09 GMT

You need to add set analysis in every expression as follows :

=only({<DATEBON={">=$(DateLower)<$(DateUpper)"}>} BUDGET)

I used only as a function, you may use sum or whatever is suitable for your data.

DateLower and DateUpper as variables the user date selection is assigned to. You cannot use a field, as this would reduce data to the selected value only (unless it is a data island)

Re: Filter table based on two dates

Mon, 15 Dec 2014 08:16:49 GMT

Hi Ioannis,

thanks for the solution. It's working

Michael