NULLASVALUE in Qliksense master dimensions

[manojkumargowda]

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' ;

[ogster1974]

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

[sibin_jacob]

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.

[nsetty]

Manoj,

Please try below...

Set NullValue = 'NULL' ;

NullAsValue Monthstart;

[uroboros]

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