Discussion Board for collaboration on QlikView Scripting.
Hi guys, it's my first time here.
here is my problem:
I'm loading some fields in a dimension table:
Code as [% Commercial ID],
Name as [Commercial name]
and the problem is that there are some missing values in the code field when I'm loading, resulting to this:
I just want to insert and display 'NA' for this case into my table. I don't know what I should use and how to use it between an If statement (into the load block) or a CASE (into sql block) ?
Go to Solution.
Try a preceding load:
If( len(trim(Code)),Code, 'NA') Code as [% Commercial ID],
you can use NullasValue function
Thank you so much Gysbert ! It was perfect.
thank you Malini ! I tried the solution provided by Gysbert and it's working, I'll try the null value function.