Remove Filtervalue From Listbox

[sabmaldun]

Hello all,

I am using a listbox as a Filter for the quarters. Attached you can find a Picture. The Values are 1,2,3,4 and NULL, because I match only the Quarter Month. Anyone has a Suggestion where in the listbox expressions I can get rid of the FilterValue 'NULL'. I googled already, but I don't know where exactly to put in the if Expression and how the exact if Expression must Sound like. Can anyone help me?

Thank you guys.

[jonathandienst]

No picture. True null values will not display in a list box, so i assume you mean a text value of "NULL". Use this in the load script before loading the table in question

SET NULLINTERPRET=NULL;

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/null-valu...