Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

fanninam
Not applicable

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
Not applicable

Re: Hide a field from a LISTBOX

if(Yourfield<>2027,Yourfield)
Learning never stops.
pradosh_thakur
Not applicable

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
Not applicable

Re: Hide a field from a LISTBOX

if(Yourfield<>2027,Yourfield)
Learning never stops.
pradosh_thakur
Not applicable

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.
sunny_talwar
Not applicable

Re: Hide a field from a LISTBOX

Another option

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

Re: Hide a field from a LISTBOX

Try this:

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

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

Highlighted
mayank_daga
Not applicable

Re: Hide a field from a LISTBOX

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