topic Re: List Box data - restrictions in QlikView

List Box data - restrictions

anthony_kinsell — Thu, 13 Feb 2014 16:21:04 GMT

Hi,

If I have a list box that displays YearMonth in the format MMM-YYYY from say Jan 2009 to Dec 2026 how do I restrict the valuse shown to say Jan'11 to Dec'14?

Re: List Box data - restrictions

luis_pimentel — Thu, 13 Feb 2014 16:26:46 GMT

At the ListBox Properties, "General Tab", you can set a "Expression" inestead of a Fieldname. Then, in that expression, add any conditions you want to. This <Expression> option should be at the bottom of your fieldnames list.

The snapshot is in Spanish, sorry:

Re: List Box data - restrictions

manojkulkarni — Thu, 13 Feb 2014 16:30:06 GMT

use expression instead of field : Expression will be if(YearMonth>='Jan-2011' AND YearMonth <='Dec-2014',YearMonth)

Re: List Box data - restrictions

anthony_kinsell — Thu, 13 Feb 2014 16:35:37 GMT

Cheers Guys,

I was trying to put the expression is the 'expressions' tab & it wasn't working.

Re: List Box data - restrictions

manojkulkarni — Fri, 14 Feb 2014 06:15:45 GMT

=if(MY>=Date(MakeDate(2013,01,01),'MMM-YY') AND MY <=Date(MakeDate(2013,12,31),'MMM-YY'),MY)

MY is your month Year in the format Jan-13. Change the format according to your requirement.