Discussion board where members can get started with Qlik Sense.
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.
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.
//A non blank value, replace '' with 'NULL' or similar
if(isnull(ABSTAT),'NULL',ABSTAT ) AS ABSTAT,
//Keep the non selectable Null value
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