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

[MarcoWedel]

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