topic Re: Selection of empty date fields with button in QlikView

Selection of empty date fields with button

Kickz86 — Fri, 15 Nov 2024 23:51:26 GMT

All I need your help!

I would like to select with a button the data which have no date in the column (Abschlußdatum).

How I need to code it in search string?

Thank you in advance!

Re: Selection of empty date fields with button

marcus_sommer — Tue, 06 Oct 2020 13:55:36 GMT

If "no date" means that those fieldvalues are NULL you couldn't select them. Within a set analysis you could do an indirect referencing (using another field) but with a direct selection I'm not sure if it's possible.

The usually better way is to set for these missing values an alternative value within the script. In your case it might look like:

if(len(trim(Abschlußdatum)), Abschlußdatum, 'no date available') as Abschlußdatum

- Marcus

Re: Selection of empty date fields with button

Belden_080 — Thu, 08 Oct 2020 04:18:59 GMT

I have the same problem but it says that it contains a null value , please suggest a solution to empty date fields .

since i could not find any solution regarding to empty fields , i have searched alot for this but i could not find any solution regarding to this ,

please suggest any solution .

Re: Selection of empty date fields with button

avinashelite — Wed, 07 Oct 2020 04:17:33 GMT

One work around to achieve this is create a new field/flag like below

if(len(trim(field_name))>0,1,0) as field_name_Empty_flag in script

then in the front end call this flag to select 0 values which in turn gives you the empty/null records

Re: Selection of empty date fields with button

Kickz86 — Wed, 07 Oct 2020 10:01:57 GMT

Hi Avinash,

thank you for the work around. I could fix my issue.

Regards,