Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

manojkumargowda
New Contributor III

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

4 Replies
ogster1974
Honored Contributor II

Re: NULLASVALUE in Qliksense master dimensions

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
Contributor III

Re: NULLASVALUE in Qliksense master dimensions

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
Contributor II

Re: NULLASVALUE in Qliksense master dimensions

Manoj,


Please try below...


Set NullValue = 'NULL' ;

NullAsValue Monthstart;

uroboros
Contributor

Re: NULLASVALUE in Qliksense master dimensions

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