topic Re: How to check two date field values are null in QlikView

How to check two date field values are null

Heena — Sat, 16 Nov 2024 02:45:36 GMT

Hi All,

I have the data as below, just few records as ex.

EID	T_Start_D	Due_D
1	1/22/2018
2	2/23/2017	_
3	_	9/23/2017
4	3/6/2019	2/23/2011
5	2/23/2017	9/23/2007
6	2/23/2017	2/13/2008
7	_	_
8	2/23/2017	2/23/2017

In Straight table, I need to show if the fields 'T_Start_D' and 'Due_D' are having values as Null or (_) values show as 'Not Required'

Thanks & Regards,

Heena Kauser

Re: How to check two date field values are null

Anil_Babu_Samineni — Tue, 13 Aug 2019 13:06:36 GMT

Try this?

If(IsNull(T_Start_D) or Match(T_Start_D, '_'), 'Not Required') -- for T_Start_D

If(IsNull(Due_D) or Match(Due_D, '_'), 'Not Required') -- for Due_D

Re: How to check two date field values are null

Heena — Tue, 13 Aug 2019 13:15:25 GMT

Hi ,

I tried this below, Not working.

=if(
(If(len(trim(T_Start_D))= 0 , 'Not Required') )
and
(If(len(trim(Due_D))= 0 , 'Not Required') )
,'Not Required')

Thanks & Regards,

Heena Kauser

Re: How to check two date field values are null

Anil_Babu_Samineni — Tue, 13 Aug 2019 13:17:34 GMT

Null part may work but not "_" one since Len('_') calculate as 1. So, It is false.

Anyway, Did you try mine?

Re: How to check two date field values are null

Heena — Tue, 13 Aug 2019 13:21:35 GMT

Hi,

=If(IsNull([Due Date]) and
IsNull([Target Audience Start Date])
, 'Not Required')

Not working.. I need both fields

Thanks & Regards,

Heena Kauser

Re: How to check two date field values are null

Heena — Tue, 13 Aug 2019 13:27:04 GMT

Sorry, My Bad. Its NULL '-' only, I have typed as '_'

Re: How to check two date field values are null

Anil_Babu_Samineni — Tue, 13 Aug 2019 13:33:11 GMT

Are you expecting similar below image? If so, use expression as follows

If(Len(T_Start_D)=0 or Match(T_Start_D, '-') or Len(Due_D)=0 or Match(Due_D, '-'), 'Not Required')

Re: How to check two date field values are null

Heena — Wed, 14 Aug 2019 05:45:02 GMT

Hi,

I need this as below.

EID	T_Start_D	Due_D	Expected
1	1/22/2018
2	2/23/2017	_
3	_	9/23/2017
4	3/6/2019	2/23/2011
5	2/23/2017	9/23/2007
6	2/23/2017	2/13/2008
7	_	_	Not Required
8	2/23/2017	2/23/2017

Thanks & Regards,

Heena Kauser

Re: How to check two date field values are null

Heena — Wed, 14 Aug 2019 13:25:25 GMT

Hi,

I tried, I am not getting the correct result.

the expected result I want is, if both date fields are Null, then the calculated field should be shown as ' not required'.

Thanks & Regards,

Heena