Discussion Board for collaboration on QlikView Scripting.
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’.
Expected result, I need in table as
Thanks in Advance
May be something like this
If(Len(Trim(T_Start_D)) = 0 and Len(Trim(Due_D)) = 0, 'Not Required')
Tried this, not working!!!
any other alternative?
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?