topic Compare Month in QlikView https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169098#M40031 <HTML><HEAD></HEAD><BODY><P>You can also try this using variables only</P></BODY></HTML> Fri, 20 Aug 2010 06:42:29 GMT 2010-08-20T06:42:29Z Compare Month https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169096#M40029 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P>I am trying to compare one month to another. The trick is I need MonthYear set as a dimension. I found the attached example which is very close I just need to move the Jul numbers to the Aug row. Here is what I need it to look like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 347pt; border-collapse: collapse;" width="461"><COLGROUP><COL style="width: 115pt; mso-width-source: userset; mso-width-alt: 5595; mso-outline-parent: collapsed;" width="153" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876; mso-outline-parent: collapsed;" width="106" /><COL style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803; mso-outline-parent: collapsed;" width="104" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl63" height="17" style="background-color: #e1e1e1; width: 115pt; height: 12.75pt; border: black 0.5pt solid;" width="153">Salesperson</TD><TD class="xl63" style="border-bottom: black 0.5pt solid; border-left: black; background-color: #e1e1e1; width: 74pt; border-top: black 0.5pt solid; border-right: black 0.5pt solid;" width="98">MonthYear</TD><TD class="xl63" style="border-bottom: black 0.5pt solid; border-left: black; background-color: #e1e1e1; width: 80pt; border-top: black 0.5pt solid; border-right: black 0.5pt solid;" width="106">Aug-2005<BR />(CM)</TD><TD class="xl63" style="border-bottom: black 0.5pt solid; border-left: black; background-color: #e1e1e1; width: 78pt; border-top: black 0.5pt solid; border-right: black 0.5pt solid;" width="104">Jul-2005<BR />(PM)</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: black 1pt solid; border-left: #ece9d8; background-color: whitesmoke; height: 12.75pt; border-top: black 1pt solid; border-right: #ece9d8;"></TD><TD class="xl65" style="border-bottom: black 1pt solid; border-left: #ece9d8; background-color: whitesmoke; border-top: black 1pt solid; border-right: #ece9d8;"></TD><TD align="right" class="xl66" style="border-bottom: black 1pt solid; border-left: black 0.5pt solid; background-color: whitesmoke; border-top: black 1pt solid; border-right: black 0.5pt solid;">$163,613</TD><TD align="right" class="xl66" style="border-bottom: black 1pt solid; border-left: black; background-color: whitesmoke; border-top: black 1pt solid; border-right: black 0.5pt solid;">$143,666</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="background-color: white; height: 12.75pt; border: black 0.5pt solid;">Brolin, Helen</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black 0.5pt solid; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black 0.5pt solid; border-right: black 0.5pt solid;">$16,946</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black 0.5pt solid; border-right: black 0.5pt solid;">$14,456</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: black 0.5pt solid; border-left: black 0.5pt solid; background-color: white; height: 12.75pt; border-top: black; border-right: black 0.5pt solid;">Callins, Joan</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$3,239</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$15,631</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: black 0.5pt solid; border-left: black 0.5pt solid; background-color: white; height: 12.75pt; border-top: black; border-right: black 0.5pt solid;">Carsson, Rob</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$20,146</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$26,097</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: black 0.5pt solid; border-left: black 0.5pt solid; background-color: white; height: 12.75pt; border-top: black; border-right: black 0.5pt solid;">Hendrix, Ingrid</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$5,629</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$14,395</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: black 0.5pt solid; border-left: black 0.5pt solid; background-color: white; height: 12.75pt; border-top: black; border-right: black 0.5pt solid;">Lindwall, Tom</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$26,072</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$30,515</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: black 0.5pt solid; border-left: black 0.5pt solid; background-color: white; height: 12.75pt; border-top: black; border-right: black 0.5pt solid;">Presley, Erik</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$12,097</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$8,577</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: black 0.5pt solid; border-left: black 0.5pt solid; background-color: white; height: 12.75pt; border-top: black; border-right: black 0.5pt solid;">Roll, Frank</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$35,276</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$14,729</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: black 0.5pt solid; border-left: black 0.5pt solid; background-color: white; height: 12.75pt; border-top: black; border-right: black 0.5pt solid;">Shine, Leif</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$19,912</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$10,705</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: black 0.5pt solid; border-left: black 0.5pt solid; background-color: white; height: 12.75pt; border-top: black; border-right: black 0.5pt solid;">Skoglund, Lennart</TD><TD align="right" class="xl68" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">Aug-2005</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$24,296</TD><TD align="right" class="xl69" style="border-bottom: black 0.5pt solid; border-left: black; background-color: white; border-top: black; border-right: black 0.5pt solid;">$8,561</TD></TR></TBODY></TABLE><BR /><BR /> <P>Any ideas would be great.</P></BODY></HTML> Thu, 19 Aug 2010 22:41:26 GMT https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169096#M40029 2010-08-19T22:41:26Z Compare Month https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169097#M40030 <HTML><HEAD></HEAD><BODY><P>Create a Calculated dimension and use this instead of your MonthYear Dimension.</P><P></P><P></P><P>=</P><P>GetFieldSelections(Month)&amp;' - '&amp;GetFieldSelections(Year)</P><BR /><BR /> <BR /><BR /></BODY></HTML> Fri, 20 Aug 2010 00:58:01 GMT https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169097#M40030 2010-08-20T00:58:01Z Compare Month https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169098#M40031 <HTML><HEAD></HEAD><BODY><P>You can also try this using variables only</P></BODY></HTML> Fri, 20 Aug 2010 06:42:29 GMT https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169098#M40031 2010-08-20T06:42:29Z Compare Month https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169099#M40032 <HTML><HEAD></HEAD><BODY><P>Thanks Santosh. This is getting a lot closer. What if mulitiple MonthYears are selected?</P></BODY></HTML> Fri, 20 Aug 2010 14:43:21 GMT https://community.qlik.com/t5/QlikView/Compare-Month/m-p/169099#M40032 2010-08-20T14:43:21Z