Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
It should be
If(IsNull("Survey Completed Date"),'non surved','surved') as Survey
Regards,
Kaushik Solanki
Or may be this if there might be white space
If(Len(Trim([Survey Completed Date])) = 0, 'non surved', 'surved') as [SurveyFlag]