Hide values in List box

[mithun_j]

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

[Chanty4u]

hi

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

[Chanty4u]

Hi,

Exclude/hide some values in Listbox of Qlikview - Stack Overflow

[Anil_Babu_Samineni]

Try like this

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

[Frank_Hartmann]

hi,

see attached file

hope this helps

[mithun_j]

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]

Thanks for your response Anil

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

[Frank_Hartmann]

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

[el_aprendiz111]

Hi,