Null values in database can lead a big problem while calculating the dimensions.
In other word we can say that it is not good if database having null values in it.
It is good if we remove all null values. in Qlikview You can set a variable which will replace all null value with some string.
In very start of script/ Main tab of your document you need to add
NullAsValue *;
Set NullValue = 'NULL' ;
and then reload the document.
Below is the image will show data behaviour "COMM" column before and after adding variable.
In other word we can say that it is not good if database having null values in it.
It is good if we remove all null values. in Qlikview You can set a variable which will replace all null value with some string.
In very start of script/ Main tab of your document you need to add
NullAsValue *;
Set NullValue = 'NULL' ;
and then reload the document.
Below is the image will show data behaviour "COMM" column before and after adding variable.
No comments:
Post a Comment