getting blanks in filter pane and in dimensions in pivot table

[nikita23]

HI Guys,

After handling the null values as below on backend , I am facing an issue with blanks values under filter pane and in dimesion which we have chose for pivot table.

if(isnull(ABSTAT),'',ABSTAT ) AS ABSTAT

please help me in avoiding this blank in filter pane.

please find the attached screenshot for the same.

[Vegar]

In Qlik Sense '' is an value, but null() is not. To avoid the blank you should either define another value in you if statement or don't use the if at all.

//Alternative 1
//A non blank value, replace '' with 'NULL' or similar
LOAD
  if(isnull(ABSTAT),'NULL',ABSTAT ) AS ABSTAT,
...


//alternative 2
//Keep the non selectable Null value
LOAD
  ABSTAT,
  ...

[nikita23]

HI Vegar,

This  if(isnull(ABSTAT),'',ABSTAT ) AS ABSTAT has been working fine in one of my dashboard no blanks values are shown in filter pane.

I an not able to understand why its not working properly on another dashboard and after applying the below logic counts has been changed on my dashboard.

if(isnull(ABSTAT),'NULL',ABSTAT ) AS ABSTAT