Discussion Board for collaboration on QlikView Scripting.
I have a calculation a- b but sometimes a or be may be null, how can I script this?
my code looks something like this at the moment:-
join(Temp table) Load *, (A) - (B) as Diff;
Go to Solution.
Try this out,
if(A = ' ', 0, A);
if(B = ' ', 0, B);
A - B = diff
This would do the job.
Could you please elaborate?
Correct me if am wrong, what I get from your question above is that sometimes the value of your A/B is equivalent to null therefore you would like to replace it with a zero?
join(Temp table) Load *, if(isnull(A), 0, (A)) - if(isnull(B), 0, (B)) as Diff;
join(Temp table) Load *, if(len(A)>0, (A), 0) - if(len(B)>0, (B), 0) as Diff;
yes I have outer joined two tables therefore I may have one value where A may be null or vice versa, I want to say if this is the case tehn convert the value to zero.
Sorry for not being clear.
Try using Alt() like this
Load*,Alt(A, 0) - Alt(B, 0) as Diff;
Hope this helps you.
Is it good practice to do the calculations before the joins?
Have you looked at using the Nullasvalue() command in your load script ?
Best Regards, Bill
No, do the joins first then proceed to do the calculations.
How do I use that in context?