topic What dimension do I use in QlikView https://community.qlik.com/t5/QlikView/What-dimension-do-I-use/m-p/227528#M79636 <HTML><HEAD></HEAD><BODY><P>Well your instinct was right, you need to use month-year or year-month (or drill down from year to month). But it looks like your Month-Year field is miscalculated. Use this for your MonthYear: date(makedate(year(AdmitDate),month(AdmitDate)),'MMM-YYYY') as MonthYear</P><P>Regards,</P></BODY></HTML> Sat, 23 Apr 2011 00:23:44 GMT vgutkovsky 2011-04-23T00:23:44Z What dimension do I use https://community.qlik.com/t5/QlikView/What-dimension-do-I-use/m-p/227527#M79635 <HTML><HEAD></HEAD><BODY><P>I need a total for each month for each year to appear on the chart. If I use the Year as the dimension I can separate the two years but the months are lumped together. If I use the month then the months separate but years do not. I tried using a month year and I also get funny results.</P><P>For example, on the attached qvw I am using the month as the Dimension and I see bars for Jan and Feb. I need to bars for Jan and Feb for both 2010 and 2011. I think I am being a little thick today.</P></BODY></HTML> Fri, 22 Apr 2011 21:54:40 GMT https://community.qlik.com/t5/QlikView/What-dimension-do-I-use/m-p/227527#M79635 dhborchardt 2011-04-22T21:54:40Z What dimension do I use https://community.qlik.com/t5/QlikView/What-dimension-do-I-use/m-p/227528#M79636 <HTML><HEAD></HEAD><BODY><P>Well your instinct was right, you need to use month-year or year-month (or drill down from year to month). But it looks like your Month-Year field is miscalculated. Use this for your MonthYear: date(makedate(year(AdmitDate),month(AdmitDate)),'MMM-YYYY') as MonthYear</P><P>Regards,</P></BODY></HTML> Sat, 23 Apr 2011 00:23:44 GMT https://community.qlik.com/t5/QlikView/What-dimension-do-I-use/m-p/227528#M79636 vgutkovsky 2011-04-23T00:23:44Z