Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
dnt503
Contributor II
Contributor II

How to combine two different logics via script

Hi, I have two logics below. One is to format the date and one is to show blanks for [Date Closed] Column. I thought it would be a simple query to put & in between the two logic but it didn't work.. any suggestions?

date(DATE_TIME_CLOSED_C,'MM/DD/YYYY')as [Date Closed],
if (len(DATE_TIME_CLOSED_C)=0 or DATE_TIME_CLOSED_C = '', 'Blank',DATE_TIME_CLOSED_C) as [Date Closed],

Labels (3)
1 Solution

Accepted Solutions
David_Friend
Support
Support

@dnt503 try using the 'if' function instead, like this:

if(len(DATE_TIME_CLOSED_C)=0 or isnull(DATE_TIME_CLOSED_C), 'Blank', date(DATE_TIME_CLOSED_C,'MM/DD/YYYY')) as [Date Closed]

does that make sense?

View solution in original post

1 Reply
David_Friend
Support
Support

@dnt503 try using the 'if' function instead, like this:

if(len(DATE_TIME_CLOSED_C)=0 or isnull(DATE_TIME_CLOSED_C), 'Blank', date(DATE_TIME_CLOSED_C,'MM/DD/YYYY')) as [Date Closed]

does that make sense?