Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
...
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