topic All dates into one marking, year 2009, 2010... in QlikView

All dates into one marking, year 2009, 2010...

Fri, 16 Dec 2011 10:55:15 GMT

I have a box with all the startdates (left in picture). My goal is to get a similar box to the one in buttom on picture. The only I get is the one in the middle and to the right, so the months are correct but I get all the year instead of just 2009, 2010, 2011 ... to cover all the post in that year. To get the months I´d used NUM(month(STARTDAT), '00') as MONTH

Anyone that have any suggestions? (Table name is startdat and month. Table in the middle is the same as startdat but just changed the document settings to date and only YYYY)

All dates into one marking, year 2009, 2010...

brenner_martina — Fri, 16 Dec 2011 11:07:42 GMT

Hi, hofstedt,

you can enter in your script the following functions, that creates fields for year, month, week,... then you can use them as a listbox:

Load

..,

date,

Month(date) As Month,

Year(date) As Year,

Week(date) as Week,

...

From ...;

Greetings from Munich

Martina

EVACO GmbH

All dates into one marking, year 2009, 2010...

Fri, 16 Dec 2011 11:21:44 GMT

Thanks, I will try. Resolved it also by input into expression editor "Year(MyDate)".

All dates into one marking, year 2009, 2010...

brenner_martina — Fri, 16 Dec 2011 11:36:24 GMT

of course you can, but in some cases you have to be careful and use DISTINCT. Listboxes from a field shows allways distinct values.