Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Isn't your question answered here: http://community.qlik.com/thread/52718?tstart=0
?
Yes but the solution was not correct
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.
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