Discussion Board for collaboration on QlikView Scripting.
I have search various use of Null values but none can fix my issue. Hope someone knows this:
column A from tblActuals
column B from tblForecasts
when I do a join, I get this (they are correct except when there is a "nothing"):
ActualAmount ForecastAmt Difference
100 120 -20
160 - - <--I want ForecastAmt to show 0, and Difference to show 160
103 150 -47
if(Len(ForecastAmt) > 0, len(ForecastAmt), '0') --- but I still get a '-'
if(IsNull(ForecastAmt), '0', ForecastAmt) --- I also get a '-'
Does anyone know what's wrong with it?
Solved! Go to Solution.
'-' says that the value is null. any mathematical operation with null gives you null
I suggest you to use Alt or RangeSum or NumSum in those cases
=ActualAmount - Alt(ForecastAmt, 0)
After I did a resident load of the same table (because I still got a '-' no matter which suggestion I tried), then all of the methods suggested worked.
I'm still not sure why it didn't work though. (I used a Table Box object to see the data)
I would mark all of you as correct if I could. Thanks so much.