I'm fairly new to qlik, so I apologise if this is a simple problem. What I'm trying to do is an isnull expression to populate a field based on two fields from different tables. My expression is:
=if(isnull(AltAccountName), AccountName, AltAccountName)
For rows 1, 2 and 4 it's working just as I want. But I can't figure out why row 3 is producing a different result to row 2 when on the surface it looks exactly the same. Can anyone suggest as to what could be causing this or is there a workaround I could try?
I don't know if this is a clue, but if I write the exact same expression down as a measure rather than dimension, it works perfectly . But unfortunately I'm looking to filter these results in the app.
Doing an =len on both field returns either the length or a null value. So using len=0 does thes same as the above.
Many thanks in advance
Solved! Go to Solution.
All expressions work, I think the problem is, data doesn't have null, its some other character.
See the sample, when I created null in place of '-', all expressions work.
Also the information shared doesn't appear correct in my sample that the expression works for 2nd row, why not for 3rd. It work as desired for 3rd as well in my sample. Using Qlikview 12.
Set NullInterpret ='-';
LOAD * inline [
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others