topic Creating a 12 month calendar from a list of dates in QlikView

Creating a 12 month calendar from a list of dates

knightwriter — Fri, 20 Mar 2015 10:22:01 GMT

I originally had an issue with single dates to a month but next problem!

Now you can see I have a list of one month many times. I want my end result to be a calendar, ie select July and my stats now show all July as a whole month and not just one day.

Re: Creating a 12 month calendar from a list of dates

prieper — Fri, 20 Mar 2015 10:25:36 GMT

Looks as if you have only formatted the date.

Please use a function like

MONTHNAME(MyDate) AS MyMonth

This field will show each occurance only once, thus being selectable

HTH Peter

Re: Creating a 12 month calendar from a list of dates

PrashantSangle — Fri, 20 Mar 2015 10:29:16 GMT

try with

Date(MonthStart(DateField,'MMMM'))

MonthName(Monthstart(DateField))

Regards

Re: Creating a 12 month calendar from a list of dates

knightwriter — Fri, 20 Mar 2015 10:45:35 GMT

Hi Peter / max,

That worked a charm. I now have the month and the year in the same text box, I would like this separated and to lose the year. See image below for expression

Re: Creating a 12 month calendar from a list of dates

prieper — Fri, 20 Mar 2015 10:50:30 GMT

Have a look into the DATE-functions in the OL-Help:

MONTH([Activity.Completed Date]) AS Month

YEAR([Activity.Completed Date]) AS Year

should deliver the results

Peter

Re: Creating a 12 month calendar from a list of dates

knightwriter — Fri, 20 Mar 2015 11:01:08 GMT

Hi Peter,

Many thanks for reply. I will certainly check it out. Is it possible to list the months as Jan Feb Mar instead of alphabetically?

Thanks again

Re: Creating a 12 month calendar from a list of dates

PrashantSangle — Fri, 20 Mar 2015 11:05:08 GMT

Hi,

Yes it is possible,

Go to property->sort->

try with Numeric->Ascending

with Expression->match(FieldName,'Jan','Feb','Mar')

Regards

Re: Creating a 12 month calendar from a list of dates

knightwriter — Fri, 20 Mar 2015 11:08:48 GMT

Lads, thank you so much.

I have a whole bunch of years list and only want 2014,2015 & 2016. How do I exlcude the others?

Re: Creating a 12 month calendar from a list of dates

PrashantSangle — Fri, 20 Mar 2015 11:35:14 GMT

Hi,

What is your expresssion for Year??

if you are using YEAR([Activity.Completed Date])

then write if(match(YEAR([Activity.Completed Date]),'2014','2015','2016'),Year)

Regards

Re: Creating a 12 month calendar from a list of dates

knightwriter — Fri, 20 Mar 2015 12:00:57 GMT

Thank you.