topic Re: Previous months selection in current year... in QlikView

Previous months selection in current year...

Anonymous — Tue, 16 Jul 2013 16:53:10 GMT

The expressions are not giving the desired results.

=vMaxYear returns the current month ie. 2013 and now i would want all the months selected suppose the current month is July. So essentially when i open the document the 2013 and months Jan,Feb,Mar,April,May,June and July should all be selected

Thanks

Kwame

Re: Previous months selection in current year...

Anonymous — Tue, 16 Jul 2013 17:11:26 GMT

Kwame,

This action works for me (I have to mention that my Month field is dual):

Action - select in field

Field - Month

Search string -

= '>=' & min({<Year={"$(=year(today()))"}>} Month) & '<=' & only({<Date={"$(=date(today()))"}>} Month)

Regards,

Michael

Re: Previous months selection in current year...

Anonymous — Tue, 16 Jul 2013 17:58:05 GMT

Hi!

It returns all the possible values in the field ie It selects all the month names

Re: Previous months selection in current year...

Anonymous — Tue, 16 Jul 2013 18:42:58 GMT

Do you have fields Month, Year, Date in your data model? Is Month field dual (or at least numeric)?

If you can upload you application or a sample, it would be easier to help...

Re: Previous months selection in current year...

Anonymous — Wed, 17 Jul 2013 07:23:03 GMT

Yes I have all these fields and importantly the month field displays just 3 abbreviated characters not dual and numberic eg Jan,Feb,Mar.

Below is the sample script of the calendar

CALENDER:

LOAD *,

Quarter&'-'&Year AS QuarterYear

;

LOAD

DATE(TempDate,'dd/MM/yyyy') AS Date,

Year(TempDate) AS Year,

'Q' & ceil(month(TempDate) / 3) AS Quarter,

date(monthstart(TempDate), 'MMM-YYYY') AS MonthYear,

Day(TempDate)AS Day,

Week(TempDate) AS Week,

Month(TempDate) AS Month

RESIDENT TEMP_CALENDER

ORDER BY TempDate Asc;

Drop table TEMP_CALENDER;

Thanks

Re: Previous months selection in current year...

Anonymous — Wed, 17 Jul 2013 12:21:25 GMT

Looks reasonable. I expect my search string to work if you replace Month with MonthYear (unless you want to select January - July for all years):

Action - select in field

Field - MonthYear

Search string -

= '>=' & min({<Year={"$(=year(today()))"}>} MonthYear) & '<=' & only({<Date={"$(=date(today()))"}>} MonthYear)