Remove Filtervalue From Listbox

sabmaldun — Sat, 16 Nov 2024 21:18:58 GMT

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.

Re: Remove Filtervalue From Listbox

jonathandienst — Mon, 04 Mar 2019 11:00:22 GMT

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-value-handling.htm

topic Re: Remove Filtervalue From Listbox in App Development

Remove Filtervalue From Listbox

Re: Remove Filtervalue From Listbox