Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bailerie
Contributor
Contributor

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

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

1 Solution

Accepted Solutions
Not applicable

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!

View solution in original post

6 Replies
Not applicable

Daniel,

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

Fabrice

Not applicable

Can you post a sample app?

Not applicable

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

bailerie
Contributor
Contributor
Author

Here is a Sample...

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

Not applicable

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!

View solution in original post

bailerie
Contributor
Contributor
Author

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