Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vijetasharma
Contributor III

Hide Values in List Box

Hello Team,

I have a list box which contains 7 values such as City Names, coming from the back end data.

Out of which only 5 City Names needs to be displayed and remaining 2 needs to be kept hidden forever from the QlikView report front end.

Example - List Box

1) Pune

2) Delhi

3) Jaipur

4) Kolkata

5) Banglore

6) Chennai

7) Bhopal

Lets say, values 1st and 7th needs to be kept hidden based on some expression writing in list box.

Kindly help me with your valuable suggestions.

Thanks.

2 Replies
pradeepreddy
Valued Contributor II

Re: Hide Values in List Box

try some thing like this....

IF(Country<>'Pune' and Country<>'Bhopal',Country)

anbu1984
Honored Contributor III

Re: Hide Values in List Box

If(Not(Match(City,'Pune','Bhopal')),City)

Community Browser