Hide Values in List Box

vijetas42 — Mon, 17 Nov 2014 07:08:05 GMT

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.

Re: Hide Values in List Box

PradeepReddy — Mon, 17 Nov 2014 07:15:16 GMT

try some thing like this....

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

anbu1984 — Mon, 17 Nov 2014 07:19:55 GMT

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