topic Monthname range selection in QlikView

Monthname range selection

Mon, 08 Nov 2010 12:05:06 GMT

Hello all,

I have an invoice date where I convert it to monthname for charting etc.

When I use it in a list box, my user can of course select it using shift/ctrl. However if they want to select it using a range, specifiying something like:

>=Mar 2009<=Apr 2010

does not work. This I guess is because monthname creates a 'dual' value where the underlying values are numeric. This can be seen by creating another numeric field in the script then using the numeric value in the month search. It would be unreasonable to expect the user to do this though!

How do I achieve this?

Regards,

Gordon

Monthname range selection

Anonymous — Mon, 08 Nov 2010 12:33:54 GMT

Gordon,
It should work if you use dates which are numereic, formatted as month names:
date(monthstart(datefield), 'MMM YYYY') as "Month Name"

Monthname range selection

Mon, 08 Nov 2010 12:53:25 GMT

Hi Gordon

You can change the number format for MonthYaer to Date and MMM YYYY

Regards

Anders

Monthname range selection

Mon, 08 Nov 2010 13:17:28 GMT

Thanks Michael and Anders,

Both solutions work!

Regards,

Gordon