Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mithun_j
Partner - Contributor
Partner - Contributor

Hide values in List box

Hi,

I have a list box which displays timeperiod values like

1. November 2016

2. December 2016

3. Overall

4. YTD(Year till date)

5. Rolling 12 Months

I need to hide the below values in my list box. Kindly let me know the expression I need to use.

1. Overall

2. YTD(Year till date)

3. Rolling 12 Months

Thanks in advance

10 Replies
Chanty4u
MVP
MVP

hi

You can 'Hide excluded' on general tab of list box properties.

Anil_Babu_Samineni

Try like this

If(WildMatch(TimePeriod, "1. November 2016","2. December 2016"), TimePeriod)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Frank_Hartmann
Master II
Master II

hi,

see attached file

hope this helps

mithun_j
Partner - Contributor
Partner - Contributor
Author

Thanks Frank,

Your solution worked.  But the problem is my time period keeps on incrementing.

For Eg:- Currently it has 5 values, but it would keep on growing in which case your solution will not work for the months January 2017.... And the one String that will be common with the future values is "201". So our expression should check for the string "201" and not for the whole month name(November 2016).

1. Overall

2. YTD(Year till date)

3. Rolling 12 Months

4. November 2016

5. December 2016

6. January 2017

7. February 2017

8....

13 August 2017

mithun_j
Partner - Contributor
Partner - Contributor
Author

Thanks for your response Anil

But your solution did not work. is there any other workaround ?

Frank_Hartmann
Master II
Master II

see attached file

hope this helps

Anil_Babu_Samineni

When you ash this is not working.  You may explain more.  I've tag below reply still I didn't understand what your intend.  Can you share data and expected output so that issue got work

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
el_aprendiz111
Specialist
Specialist

Hi,

lstbx.gif