Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to know how to apply this expression IF(FIND("HO1",UPPER([Field_Text]))<>"",VALUE([Field_Date])+VALUE([Field_Time]),"") in excel file to qlik sense
Now I used the If(len(WildMatch(UPPER([Field_Text]),'HO1'))=0,Null(),timestamp(Date#([Field_Date], 'MM/DD/YYYY')+Time#([Field_Time], 'hh:mm'), 'DD/MM/YYYY hh:mm')) but this expression is not working.
Could you please fix this formula?
Thank you
Try like:
If(WildMatch(UPPER([Field_Text]),'*HO1*')) , timestamp(Date#([Field_Date], 'MM/DD/YYYY')+Time#([Field_Time], 'hh:mm'), 'DD/MM/YYYY hh:mm'))
tresesco,
Thank you, I'm using your expression but the data shown null in all row, although the data in Field_Text have 'HO1' in text.
The problem could lie in other part of your expression, let's figure that out. Try this:
If(WildMatch(UPPER([Field_Text]),'*HO1*')) , 'Found') as Test
If you find 'Found' is appearing, you are sure that the issue is with date#()...
tresesco,
Yes, 'Found' is appearing.
but now I don't know how to show Date and Time on some Field in this Field
Now it's about getting your timestamp fields rightly loaded. You need date#() or time#() when your fields are read by qlik as strings. However, there is a chance that they are actually being read as timestamp and then you don't need to parse them. You could just try like:
timestamp([Field_Date] +[Field_Time], 'DD/MM/YYYY hh:mm')