Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
fanninam
New Contributor II

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.
Highlighted
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.
Highlighted
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)
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!
Community Browser