Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

fanninam
New Contributor III

Hide a field from a LISTBOX

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

2 Solutions

Accepted Solutions
pradosh_thakur
Honored Contributor II

Re: Hide a field from a LISTBOX

if(Yourfield<>2027,Yourfield)
Learning never stops.
pradosh_thakur
Honored Contributor II

Re: Hide a field from a LISTBOX

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

or

pick(Match(Your_field,2027)+1,Your_field,null())
Learning never stops.
6 Replies
pradosh_thakur
Honored Contributor II

Re: Hide a field from a LISTBOX

if(Yourfield<>2027,Yourfield)
Learning never stops.
pradosh_thakur
Honored Contributor II

Re: Hide a field from a LISTBOX

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

or

pick(Match(Your_field,2027)+1,Your_field,null())
Learning never stops.

Re: Hide a field from a LISTBOX

Another option

Aggr(Only({1<Year = e({<Year = {2027}>})>}) Year), Year)
Highlighted
mayank_daga
New Contributor

Re: Hide a field from a LISTBOX

Try this:

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

Re: Hide a field from a LISTBOX

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
New Contributor

Re: Hide a field from a LISTBOX

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