topic Re: Re: Date, year(date) and month(date) question in QlikView

Date, year(date) and month(date) question

bailerie — Thu, 05 Dec 2013 08:13:19 GMT

Hi,

I'm totally new to app development. and a beginner to QV but I'm trying to get two list boxes from the one date column. one for year and one for month. I've used the expressions year(Date) and month(Date) from the Date field on the table. however when I select for e.g. 2013 and then Jan:Jun in the month list box. It shows me Jan to June in all years.

Any suggestions greatly appreciated.

Regards

Dan

Re: Date, year(date) and month(date) question

Thu, 05 Dec 2013 08:21:08 GMT

Daniel,

You should create several fields or dimensions (Month, Year) during the load script

Fabrice

Re: Date, year(date) and month(date) question

Thu, 05 Dec 2013 08:25:22 GMT

Can you post a sample app?

Re: Date, year(date) and month(date) question

Thu, 05 Dec 2013 08:28:08 GMT

In Script editor

if u have date field,

then apply filed names like this

Year(Date) as year

month(Date) as Month

Day(Date) as Day like wise

so many functions are there still u if u want monthend(fieldname),Monthname(fieldname);

in load script u have to write

Re: Re: Date, year(date) and month(date) question

bailerie — Thu, 05 Dec 2013 08:33:27 GMT

Here is a Sample...

I'm not sure what the script should look like then.

Re: Re: Re: Date, year(date) and month(date) question

Thu, 05 Dec 2013 08:57:47 GMT

Hi Daniel,

PFA. I have taken a sample data from your script and done the changes accordingly. See the "Test" tab in qvw.

Key here is to create the Month & Year in script itself instead of creating them in front end.

Hope it helps!

Re: Re: Re: Date, year(date) and month(date) question

bailerie — Thu, 05 Dec 2013 09:04:52 GMT

Thanks, That Works when I load in Script...