Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try some thing like this....
IF(Country<>'Pune' and Country<>'Bhopal',Country)
If(Not(Match(City,'Pune','Bhopal')),City)