topic Re: MonthYear in QlikView https://community.qlik.com/t5/QlikView/MonthYear/m-p/9685#M511385 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Sum({&lt;SurgeryMonthYear = p(MonthYear), MonthYear, Day, Year, Month, Quarter&gt;}WI_EUR)</STRONG></P></BODY></HTML> Mon, 12 Feb 2018 16:32:10 GMT sunny_talwar 2018-02-12T16:32:10Z MonthYear https://community.qlik.com/t5/QlikView/MonthYear/m-p/9684#M511384 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have 2 different dimension:</P><P></P><P>- <STRONG>MonthYear</STRONG></P><P>- <STRONG>SurgeryMonthYear</STRONG></P><P></P><P></P><P>I would like to select in my report the MonthYearServices based on the MonthYear selection. So just selection on MonthYear should be done.&nbsp; Is something possible?</P><P></P><P>I'm using this formula but is not working</P><P></P><P>=Sum({&lt;SurgeryMonthYear={$(=concat(chr(39) &amp; MonthYear &amp; chr(39),',') },MonthYear=,Day=,Year=,Month=,Quarter=&gt;}WI_EUR)</P><P></P><P>Can anyone please advise?</P><P>Thank you</P></BODY></HTML> Mon, 12 Feb 2018 16:31:04 GMT https://community.qlik.com/t5/QlikView/MonthYear/m-p/9684#M511384 qlikviewaf 2018-02-12T16:31:04Z Re: MonthYear https://community.qlik.com/t5/QlikView/MonthYear/m-p/9685#M511385 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Sum({&lt;SurgeryMonthYear = p(MonthYear), MonthYear, Day, Year, Month, Quarter&gt;}WI_EUR)</STRONG></P></BODY></HTML> Mon, 12 Feb 2018 16:32:10 GMT https://community.qlik.com/t5/QlikView/MonthYear/m-p/9685#M511385 sunny_talwar 2018-02-12T16:32:10Z