Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ebrahimaljefri
New Contributor III

Is null Function

hi ,

i am using Qlik sense desktop and i want to use is null function i wrote below function and it works but does not return what i want  :

If(IsNull("Survey Completed Date"),'non surved',If(IsNull("Survey Completed Date"),'surved')) as Survey completed date1

3 Replies
arvind_patil
Valued Contributor II

Re: Is null Function

Hi Ibrahibra,

I will do in this way:

If(isnull("Survey Completed Date"),'Non Surved',"Survey Completed Date") as [Survey completed date1]


Thanks,

Arvind patil

Re: Is null Function

Hi,

It should be

If(IsNull("Survey Completed Date"),'non surved','surved') as Survey


Regards,

Kaushik Solanki

MVP
MVP

Re: Is null Function

Or may be this if there might be white space

If(Len(Trim([Survey Completed Date])) = 0, 'non surved', 'surved') as [SurveyFlag]