topic Re: Comparison between 2 independant dimensions in QlikView https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383814#M491674 <HTML><HEAD></HEAD><BODY><P>Whiteline,</P><P>thanks a lot! I don't really understand that set analysis expression, but it works&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P>Florian</P></BODY></HTML> Wed, 05 Sep 2012 07:40:56 GMT pennetzdorfer 2012-09-05T07:40:56Z Comparison between 2 independant dimensions https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383810#M491670 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>Probably an easy one, but I can't figure out ...</P><P></P><P>In my Sales application I've got two different fields for Sales representative:</P><UL><LI><EM>HistoricSalesRep</EM> from Sales table</LI><LI><EM>CurrentSalesRep</EM> from Customer master table</LI></UL><P></P><P>Now I would like to compare Sales between those 2 fields. For example:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales Rep</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Historic</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Current</STRONG></SPAN></TH></TR><TR><TD>A</TD><TD style="text-align: right;">1,265</TD><TD style="text-align: right;">1,150</TD></TR><TR><TD>B</TD><TD style="text-align: right;">2,458</TD><TD style="text-align: right;">2,581</TD></TR><TR><TD>C</TD><TD style="text-align: right;">1,859</TD><TD style="text-align: right;">1,737</TD></TR><TR><TD>D</TD><TD style="text-align: right;">5,887</TD><TD style="text-align: right;">6,001</TD></TR><TR><TD><STRONG>Total</STRONG></TD><TD style="text-align: right;"><STRONG>11,469</STRONG></TD><TD style="text-align: right;"><STRONG>11,469</STRONG></TD></TR></TBODY></TABLE><P></P><P>Does anybody know how to achieve that?</P><P></P><P>Regards,</P><P>Florian</P></BODY></HTML> Tue, 04 Sep 2012 11:57:52 GMT https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383810#M491670 pennetzdorfer 2012-09-04T11:57:52Z Re: Comparison between 2 independant dimensions https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383811#M491671 <HTML><HEAD></HEAD><BODY><P>Create a chart with:</P><P>dimension: CurrentSalesRep</P><P>expression1: Sum(CurrentSales)</P><P>expression2: Sum({$&lt;HistoricSalesRep=P(CurrentSalesRep)&gt;} HistoricSales)</P></BODY></HTML> Tue, 04 Sep 2012 12:48:35 GMT https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383811#M491671 whiteline 2012-09-04T12:48:35Z Re: Comparison between 2 independant dimensions https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383812#M491672 <HTML><HEAD></HEAD><BODY><P>Hey whiteline,</P><P></P><P>thx for you suggestion. Unfortunately both expressions return the same values ...</P></BODY></HTML> Tue, 04 Sep 2012 13:02:17 GMT https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383812#M491672 pennetzdorfer 2012-09-04T13:02:17Z Re: Comparison between 2 independant dimensions https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383813#M491673 <HTML><HEAD></HEAD><BODY><P>Ah,</P><P>istead the second one try:</P><P>=Sum({$&lt;HistoricSalesRep={"=HistoricSalesRep=CurrentSalesRep"}&gt;} HistoricSales)</P></BODY></HTML> Tue, 04 Sep 2012 14:35:17 GMT https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383813#M491673 whiteline 2012-09-04T14:35:17Z Re: Comparison between 2 independant dimensions https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383814#M491674 <HTML><HEAD></HEAD><BODY><P>Whiteline,</P><P>thanks a lot! I don't really understand that set analysis expression, but it works&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P>Florian</P></BODY></HTML> Wed, 05 Sep 2012 07:40:56 GMT https://community.qlik.com/t5/QlikView/Comparison-between-2-independant-dimensions/m-p/383814#M491674 pennetzdorfer 2012-09-05T07:40:56Z