topic Re: Hide values in List box in QlikView

Hide values in List box

mithun_j — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Hide values in List box

Chanty4u — Fri, 25 Nov 2016 12:11:42 GMT

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

Re: Hide values in List box

Chanty4u — Fri, 25 Nov 2016 12:14:10 GMT

Hi,

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

Re: Hide values in List box

Anil_Babu_Samineni — Fri, 25 Nov 2016 12:18:05 GMT

Try like this

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

Re: Hide values in List box

Frank_Hartmann — Fri, 25 Nov 2016 12:19:43 GMT

hi,

see attached file

hope this helps

Re: Hide values in List box

mithun_j — Fri, 25 Nov 2016 12:59:39 GMT

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

Re: Hide values in List box

mithun_j — Fri, 25 Nov 2016 13:00:44 GMT

Thanks for your response Anil

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

Re: Hide values in List box

Frank_Hartmann — Fri, 25 Nov 2016 13:44:57 GMT

see attached file

hope this helps

Re: Hide values in List box

Anil_Babu_Samineni — Fri, 25 Nov 2016 14:40:52 GMT

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

Re: Hide values in List box

el_aprendiz111 — Fri, 25 Nov 2016 14:50:15 GMT

Hi,

Re: Hide values in List box

MarcoWedel — Fri, 25 Nov 2016 22:14:45 GMT

Hi,

another solution could be to load month names as dual dates, the other values as text and to use a listbox expression that checks for numeric values (<>0):

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

table1:
LOAD Date#(timeperiod, 'MMMM YYYY') as timeperiod
Inline [
timeperiod
November 2016
December 2016
January 2017
February 2017
August 2017
Overall
YTD(Year till date)
Rolling 12 Months
];

hope this helps

regards

Marco