Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to custom the month, year??

I have attached a qv application. It will have data received as a date column and i have below query to get year, day and month.

year([Date Received]) as year,

day([Date Received]) as day

,Month([Date Received]) AS Month

Now the main thing i need is a new field month which should satisfy the below thing , whenver i include month as a list box it should show the jan month to current month.

Examples:

forFebruary 2012 you would pull January 2012 and February 2012 YTD info

forMarch 2012 you would pull Jan 2012, Feb 2012 and Mar 2012 YTD info

4 Replies
Anonymous
Not applicable
Author

Isn't your question answered here: http://community.qlik.com/thread/52718?tstart=0

?

Not applicable
Author

Yes but the solution was not correct

Not applicable
Author

The month field should contain only the completed month list of current year( even the year may be 2010,2011) and remaining month should not be shown in the list box. How to create such month field using variable.

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

This looks like a "year to date" problem. Search on this sit for "year to date" or YTD and you should find examples and discussion.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein