This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have table like these...
I want replace empty value with Active statement. Can you please suggest me
On Dimension or data load: if (isnull(EndDate),'Active',EndDate)
if you loading data from excel or database what Thi Pham suggested is correct but if you loading data from csv or text files then there won't be null concept, so use the below
Thank Kiran to fix me, it's a best practice to check both null & empty in this case, then it should be :
if (isnull(EndDate) or len(EndDate)=0,'Active',EndDate)
Yep you are correct,
please mark it correct or self assumed so that it can be helpful for others
If you want to treat nulls and empty strings the same, then this is sufficient:
=if(len(EndDate)=0, 'Active', EndDate)
A null value has a length of zero