
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
NULLASVALUE in Qliksense master dimensions
Hi All,
I have a month column with some null values. And then I have created a master dimension based on this month column to restrict some values and then I'm using this master dimension everywhere. I have a list box with master dimension (month column) as dimension. Now I need to display Null values as 'NULL' in the list box and other charts so that users can select NULL values. I used below NULLASVALUE function on the month column, but it is not working for master dimensions. Please suggest how can I have "NULL" string in place of actual null in master dimension..
NullAsValue Monthstart;
Set NullValue = 'NULL' ;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In your script can you replace NULL values with N/A or unknown for example.
You can use IsNull() to check for the state and then replace with a value you can filter on.
Regards
Andy


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create new column in the script.
if(isnull(month_column),'NULL',month_column) as month_column_new
Create the Master Dimension using the New column.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Manoj,
Please try below...
Set NullValue = 'NULL' ;
NullAsValue Monthstart;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Manoj! This issue could be caused by you're loadind data on optimized QVD; try to load with an adding for one field.
It will work, your sintax for nullasnull and nullvalue it's rigth, the problem it's on data load.
Regards
