Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is there a way to carry all values nulls to 0 in all fields?
I´m reading many xls. Each xls has values nulls that thrown bad results in my final formulas. Is because QlikView is not taking that values into the analysis and formulas. I would like that in my load model when qlikview find a null value.. this value be transform to 0...
Thanks!
May be using NullAsValue
QlikView Addict: Handling Nulls in QlikView
NullAsValue *;
SET NullValue = 0;
You can look into
NullAsValue *;
SET NullValue = 0;
Hi,
Thank you for your reply,
I Try:
NullAsValue *;
Set NullValue = '0';
NullAsValue *;
Set NullValue = '';
NullAsValue *;
Set NullValue = '<NULL>';
Nothing Happened...
Could you upload a sample Excel file? Are these nulls really NULL and not just empty values?
I think NullAsValue cannot handle null values created by join. Is it possible that you are doing a join which might be creating these nulls for you?
Empty Values,
As you can see in the first post (Image) The spaces are empty.
I would like to fill up with 0 values.
Thanks!
Hi Sunny,
The answers is no... Im readind the base directly from xls. There is no join and nothing about it...