topic Select broken years in QlikView

Select broken years

Mon, 31 Dec 2012 10:45:30 GMT

I present Year and Month apart from each other in two list boxes. How do I select a broken year, such as November 2012 till Oktober 2013?

Now I see January till December for the years 2012 and 2013.

Mon, 31 Dec 2012 14:12:24 GMT

Hello,

You can achieve this by adding in your script a field (as MonthYear) that combines both of Year and Month together like this:

LOAD Year,

Month,

Month & '-' & Year as MonthYear,

etc...

Or if you have the actual date you can do this:

LOAD TrxDate,

Year(TrxDate) as Year,

Month(TrxDate) as Month,

Date(MonthStart(TrxDate), 'MMM-YYYY') as MonthYear

etc...

Then simply use that MonthYear field as a listbox.

Hope this helps.

Or — Mon, 31 Dec 2012 14:33:05 GMT

Monthname(TrxDate) does the trick quite nicely.