Discussion board where members can get started with QlikView.
below link i checked
Mapt - Developer skills delivered
I am bit confused on below ISnull scenario Can anyone give some clarification on this?
If(IsNull(Sales), 0, Sales) As Sales
if i use --- If(IsNull(Sales), 0, Sales) As Sales this condition still giving same results if not also same.
how it is used?
Go to Solution.
Inline load is like text file, it can't contain NULL values. If you want to get the impact of NULL in inline load try like:
Set NullInterpret = '';
You can use Alt() that returns the first non-null values
If(IsNull(Sales), 0, Sales) == Alt(Sales,0)
its working as expcected
you should define null value then it will work fine.
yes satti its working fine now