topic Re: Select in field selects all when filter is not hit in QlikView

Select in field selects all when filter is not hit

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a "Select in Field" action in a post reload event. It selects the current day with the following search string:

=Date(Today(),'DD/MM/YYYY')

Sometimes it happens that I have no data for that day and the filter is not hit. When this happens it selects all data and exports them from the beginning of time.

Is there a way to avoid this behaviour or at least intercept it someway?

Thanks in advance.

Re: Select in field selects all when filter is not hit

Anonymous — Thu, 24 Aug 2017 09:24:32 GMT

Hi,

you should use a calendar table with all days of the year.

Link this calendar to your data table. Then apply the "Select in Field" action on the date field of the calendar.

Then the filter will work and you will have no data as you want

Re: Select in field selects all when filter is not hit

tresB — Thu, 24 Aug 2017 09:26:28 GMT

Could you post a sample that demonstrates the issue?

Re: Select in field selects all when filter is not hit

antoniotiman — Thu, 24 Aug 2017 09:39:10 GMT

Hi Nicola,

Maybe

Assuming You have data for <=Today()

Date(Max({1} YourDateField),'DD/MM/YYYY')

Regards,

Antonio