topic Help Needed !Selecting Corresponding Year with a Particular Month! in QlikView https://community.qlik.com/t5/QlikView/Help-Needed-Selecting-Corresponding-Year-with-a-Particular-Month/m-p/553979#M1145103 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a sales data Datewise and while creatig an application i used these two expressions "=Yearname([Orderdate])" &amp; "=Month([orderdate])" to segregate the data Year and Month wise. But now when i am selecting Months say Jan , Feb etc it is showing me data of all the years from 2009-2012. But i want to see for a particular year (2009)and particular month(say Jan) but not for all the years. Is there any way i can corelate these two prameters so that i can view data for a particular year and month?</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 02 Aug 2013 14:25:45 GMT 2013-08-02T14:25:45Z Help Needed !Selecting Corresponding Year with a Particular Month! https://community.qlik.com/t5/QlikView/Help-Needed-Selecting-Corresponding-Year-with-a-Particular-Month/m-p/553979#M1145103 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a sales data Datewise and while creatig an application i used these two expressions "=Yearname([Orderdate])" &amp; "=Month([orderdate])" to segregate the data Year and Month wise. But now when i am selecting Months say Jan , Feb etc it is showing me data of all the years from 2009-2012. But i want to see for a particular year (2009)and particular month(say Jan) but not for all the years. Is there any way i can corelate these two prameters so that i can view data for a particular year and month?</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 02 Aug 2013 14:25:45 GMT https://community.qlik.com/t5/QlikView/Help-Needed-Selecting-Corresponding-Year-with-a-Particular-Month/m-p/553979#M1145103 2013-08-02T14:25:45Z Re: Help Needed !Selecting Corresponding Year with a Particular Month! https://community.qlik.com/t5/QlikView/Help-Needed-Selecting-Corresponding-Year-with-a-Particular-Month/m-p/553980#M1145104 <HTML><HEAD></HEAD><BODY><P>You can create a monthyear field from your date field: monthname(OrderDate) as MonthYear. You can use that instead of Month if you want a specific month from a specific year. </P><P></P><P>Or you could simply select both a year and a month.</P></BODY></HTML> Fri, 02 Aug 2013 16:32:17 GMT https://community.qlik.com/t5/QlikView/Help-Needed-Selecting-Corresponding-Year-with-a-Particular-Month/m-p/553980#M1145104 Gysbert_Wassenaar 2013-08-02T16:32:17Z