topic Re: Select in field | to select date range and Null values in QlikView

Select in field | to select date range and Null values

devaljain5 — Sat, 16 Nov 2024 02:47:13 GMT

Hi All,

I have a requirement where if the user selects a Application Start and End Date, the straight table should display data within the Application start and end date range and also where application date is NULL. I am using the Select in Field Trigger but it's not working. Below is my expression:

='>='&Date(vStartDate,'MM/DD/YYYY') & '<='&Date(vEndDate,'MM/DD/YYYY') & '=' & ''

Please suggest

Re: Select in field | to select date range and Null values

Anil_Babu_Samineni — Thu, 08 Aug 2019 16:02:23 GMT

Why Actions needed? I assume, Start Date and End Date is coming from one Field. If so, You can try below as dimension.

If(DateField>=Max(TOTAL [Start Date]) and DateField<=Max([End Date]), DateField)

Re: Select in field | to select date range and Null values

devaljain5 — Thu, 08 Aug 2019 16:50:26 GMT

Hi Anil,

The selection is based on the filter (Calendar), hence based on the value user selects, the trigger should selection the dates within the date range and NULL values. Hence, using a trigger here.

Re: Select in field | to select date range and Null values

Anil_Babu_Samineni — Thu, 08 Aug 2019 16:54:18 GMT

Why = and other symbols in the end? Can't you use simply as string and Field from Date?

='>='&Date(vStartDate,'MM/DD/YYYY') & '<='&Date(vEndDate,'MM/DD/YYYY')

Re: Select in field | to select date range and Null values

devaljain5 — Thu, 08 Aug 2019 16:56:21 GMT

Because I need records where the [Date Field] is NULL as well

Re: Select in field | to select date range and Null values

Anil_Babu_Samineni — Thu, 08 Aug 2019 17:02:03 GMT

Your syntax won't work. If you want null values try to enable the null values check box in the report?

Re: Select in field | to select date range and Null values

devaljain5 — Thu, 08 Aug 2019 17:35:14 GMT

Had to add below lines to the load script:

NullAsValue [Application Date];
Set NullValue = 'NULL';

AND the below expression in the trigger:

='(>=' & Date(vStartDate,'MM/DD/YYYY') & '<='&Date(vEndDate,'MM/DD/YYYY') & ' | NULL)'.

If someone has a solution without converting actual NULL value to 'NULL' value, please suggest.

Re: Select in field | to select date range and Null values

Anil_Babu_Samineni — Thu, 08 Aug 2019 17:42:58 GMT

Perhaps this? You can still use Error Handling and try below for string

=('>=' & Date(vStartDate,'MM/DD/YYYY') & '<='&Date(vEndDate,'MM/DD/YYYY') | 'NULL')

Re: Select in field | to select date range and Null values

devaljain5 — Thu, 08 Aug 2019 17:52:14 GMT

Nayyy. Didn't work.

Gave syntax error and when adjusted to get rid of error, didn't pull the Null values.

Thanks for trying. _/\_