topic Re: Simple Date Graph in QlikView https://community.qlik.com/t5/QlikView/Simple-Date-Graph/m-p/907643#M990214 <HTML><HEAD></HEAD><BODY><P>Thanks again sunindia, great stuff.</P></BODY></HTML> Tue, 21 Jul 2015 11:13:54 GMT knightwriter 2015-07-21T11:13:54Z Simple Date Graph https://community.qlik.com/t5/QlikView/Simple-Date-Graph/m-p/907641#M990212 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Basic question here. I want to create a graph showing:</P><P></P><UL><LI>medals won in 2015</LI><LI>By month (x-axis)</LI><LI>Count the medals per month</LI></UL><P></P><P>my fields available are:</P><P></P><UL><LI>[Medal.Won/Lost Date] </LI><LI>[Medal.Status]= 'Won'</LI></UL><P></P><P>I cannot get this expression as I need to use the Won/Lost date as both the InYear and month.</P><P></P><P>Appreciate any help</P></BODY></HTML> Tue, 21 Jul 2015 10:23:27 GMT https://community.qlik.com/t5/QlikView/Simple-Date-Graph/m-p/907641#M990212 knightwriter 2015-07-21T10:23:27Z Re: Simple Date Graph https://community.qlik.com/t5/QlikView/Simple-Date-Graph/m-p/907642#M990213 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P>Dimension: <STRONG>MonthName(</STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>[Medal.Won/Lost Date])</STRONG></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Expression: <STRONG>Count({&lt;Year = {'2015'}, [Medal.Status] = {'Won'}&gt;} [Medal.Status])</STRONG></SPAN></P></BODY></HTML> Tue, 21 Jul 2015 10:26:15 GMT https://community.qlik.com/t5/QlikView/Simple-Date-Graph/m-p/907642#M990213 sunny_talwar 2015-07-21T10:26:15Z Re: Simple Date Graph https://community.qlik.com/t5/QlikView/Simple-Date-Graph/m-p/907643#M990214 <HTML><HEAD></HEAD><BODY><P>Thanks again sunindia, great stuff.</P></BODY></HTML> Tue, 21 Jul 2015 11:13:54 GMT https://community.qlik.com/t5/QlikView/Simple-Date-Graph/m-p/907643#M990214 knightwriter 2015-07-21T11:13:54Z