Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Heena
Contributor III
Contributor III

If two date fields are null, then show nulls as value in calculated dimension

Hi,

I have two date fields, containing values as well as nulls.

I need to show status (which is a calculated dimension) based on these two date fields.

If both date fields are null, then status is ‘Not Required’.

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

 

 

Expected result, I need in table as

 

EID

T_Start_D

Due_D

Status

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 in Advance

 

Regards,

Heena

3 Replies
sunny_talwar

May be something like this

If(Len(Trim(T_Start_D)) = 0 and Len(Trim(Due_D)) = 0, 'Not Required')
Heena
Contributor III
Contributor III
Author

Hi,

Tried this, not working!!!

any other alternative?

Regards,

Heena

sunny_talwar

Lol if this didn't work, I am not sure what the alternative will do... are you able to share a sample where we can see the issue?