topic Re: Month/Year repeating and Sort in QlikView https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45732#M510896 <HTML><HEAD></HEAD><BODY><P>There are no data points in the line graph?</P></BODY></HTML> Wed, 02 May 2018 19:00:56 GMT cbaqir 2018-05-02T19:00:56Z Month/Year repeating and Sort https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45730#M510894 <HTML><HEAD></HEAD><BODY><P>I know I have run into this before and suspect I need to do something like add another dimension in my AGGR statement but I can't figure out what is happening...</P><P></P><P>I want the months in the Readmits per Month line chart to show Jul 2013, Aug 2013, Sept 2013 etc but Jul 2013 shows up multiple times etc with the dimension of <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ADMIT_DATE</SPAN><SPAN style="font-size: 8pt;">, 'YYYY-MMM') </SPAN></P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 02 May 2018 17:23:39 GMT https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45730#M510894 cbaqir 2018-05-02T17:23:39Z Re: Month/Year repeating and Sort https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45731#M510895 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=Date(MonthStart(ADMIT_DATE), 'YYYY-MMM')</STRONG></P></BODY></HTML> Wed, 02 May 2018 18:07:01 GMT https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45731#M510895 sunny_talwar 2018-05-02T18:07:01Z Re: Month/Year repeating and Sort https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45732#M510896 <HTML><HEAD></HEAD><BODY><P>There are no data points in the line graph?</P></BODY></HTML> Wed, 02 May 2018 19:00:56 GMT https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45732#M510896 cbaqir 2018-05-02T19:00:56Z Re: Month/Year repeating and Sort https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45733#M510897 <HTML><HEAD></HEAD><BODY><P>I saw that too... can you create a field in the script instead of using a calculated dimension and use that in your aggr() expression?</P></BODY></HTML> Wed, 02 May 2018 19:36:53 GMT https://community.qlik.com/t5/QlikView/Month-Year-repeating-and-Sort/m-p/45733#M510897 sunny_talwar 2018-05-02T19:36:53Z