topic Re: Hide a field from a LISTBOX in QlikView

Hide a field from a LISTBOX

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

Need to hide a field from a LISTBOX. For example, I want to not show 2027 (they used it as a test year).

pradosh_thakur — Mon, 11 Feb 2019 14:50:00 GMT

if(Yourfield<>2027,Yourfield)

pradosh_thakur — Mon, 11 Feb 2019 14:52:24 GMT

IF(Your_field =2027,null(),Your_field)

pick(Match(Your_field,2027)+1,Your_field,null())

sunny_talwar — Mon, 11 Feb 2019 15:02:07 GMT

Another option

Aggr(Only({1<Year = e({<Year = {2027}>})>}) Year), Year)

mayank_daga — Mon, 11 Feb 2019 18:44:57 GMT

Try this:

AGGR(CONCAT({1<Year-={'2027'}>} Year), Year)

sunny_talwar — Mon, 11 Feb 2019 18:49:25 GMT

The problem is that as soon as your select a Year, the other Years will vanish. May be you wanted this

AGGR(CONCAT({1<Year=-{'2027'}>} Year), Year)

minus sign after = and not before

mayank_daga — Mon, 11 Feb 2019 18:52:04 GMT

Yes, I'm sorry. Typo.. using a mobile to answer!