Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I don't understand why, but in my table after loading, i can see values with " - " symbole and values empty...
Is it possible to set all values with " - " ?
Exemple :
Thanx
See this post
http://qlikviewcookbook.com/2013/01/filling-default-values-using-mapping/
for a suggested method of standardizing and converting your blanks to null(). Similar to Rupert's ApplyMap() suggestion but MAP USING can be easier to use when you have many fields.
-Rob
As a Novice QV developer I usually handle nulls using the following
- In the edit script 'Main tab' Set the variables as below
SET NullIntrepret = ''; // If loading data from Table files or Inline tables
SET NullDisplay =''; // If Loading data using ODBC/OLEDB connections
Then using ISNULL or ALT functions to transform accordingly.
Eg Data:
Script:
Table1:
LOAD Dates,
Article,
if(IsNull(Article),'No Data',Article) AS [ifNullHandled],
Alt(Article,'NoValue') AS [AltNullHandling]
FROM
(
Any insights on the above will be much appreciated.