Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

getting blanks in filter pane and in dimensions in pivot table

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.

2 Replies
Highlighted
Partner
Partner

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,
  ...

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Contributor III
Contributor III

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