Filtering a table based on a list box value

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a list box which contains dates.

My requirement is to create a filter on my table which will show the value for max(Date) (by default).

I can't use "Select In Field" at Document level, as I need this filter only for this table. I have other tables in my page as well which shows All days data.

Can you please help.

Re: Filtering a table based on a list box value

Vegar — Fri, 23 Aug 2019 22:11:14 GMT

Add a set analysis into your expressions.

Like this: Sum({<Date={'$(=maxstring([Date]))'}>}Qty)

topic Re: Filtering a table based on a list box value in QlikView

Filtering a table based on a list box value

Re: Filtering a table based on a list box value