topic How can I solve this problem in SET ANALYSIS? in QlikView

topic How can I solve this problem in SET ANALYSIS? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-solve-this-problem-in-SET-ANALYSIS/m-p/222337#M75017 <HTML><HEAD></HEAD><BODY><P>I attach a qvw with data to solve the problem in set analysis</P><P>This is the solution:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 259pt; border-collapse: collapse;" width="344"><COLGROUP><COL style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82" /><COL style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79" /><COL style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" width="49" /><COL style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;" width="52" /><COL style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl26" height="17" style="width: 62pt; height: 12.75pt; background-color: silver; border: #ece9d8;" width="82"><STRONG>MARCA</STRONG></TD><TD class="xl26" style="width: 59pt; background-color: silver; border: #ece9d8;" width="79"><STRONG>MARCA_EQ</STRONG></TD><TD class="xl26" style="width: 37pt; background-color: silver; border: #ece9d8;" width="49"><STRONG>MES</STRONG></TD><TD class="xl26" style="width: 39pt; background-color: silver; border: #ece9d8;" width="52"><STRONG>VALOR</STRONG></TD><TD class="xl26" style="width: 62pt; background-color: silver; border: #ece9d8;" width="82"><STRONG>EXPRESION</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #ece9d8;">FORD</TD><TD class="xl24" style="background-color: yellow; border: #ece9d8;">F100</TD><TD align="right" class="xl24" style="background-color: yellow; border: #ece9d8;">200911</TD><TD align="right" style="background-color: transparent; border: #ece9d8;">10</TD><TD align="right" class="xl24" style="background-color: yellow; border: #ece9d8;">20</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="height: 12.75pt; background-color: yellow; border: #ece9d8;">F100</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl24" style="background-color: yellow; border: #ece9d8;">200911</TD><TD align="right" class="xl24" style="background-color: yellow; border: #ece9d8;">20</TD><TD style="background-color: transparent; border: #ece9d8;"></TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #ece9d8;">FORD</TD><TD class="xl25" style="background-color: #ccffcc; border: #ece9d8;">F100</TD><TD align="right" class="xl25" style="background-color: #ccffcc; border: #ece9d8;">200912</TD><TD align="right" style="background-color: transparent; border: #ece9d8;">15</TD><TD align="right" class="xl25" style="background-color: #ccffcc; border: #ece9d8;">25</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="height: 12.75pt; background-color: #ccffcc; border: #ece9d8;">F100</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="background-color: #ccffcc; border: #ece9d8;">200912</TD><TD align="right" class="xl25" style="background-color: #ccffcc; border: #ece9d8;">25</TD><TD style="background-color: transparent; border: #ece9d8;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>I hope you can help</P><P>Thanks a lot.</P><P></P><P></P></BODY></HTML> Tue, 26 Jan 2010 14:37:44 GMT 2010-01-26T14:37:44Z How can I solve this problem in SET ANALYSIS? https://community.qlik.com/t5/QlikView/How-can-I-solve-this-problem-in-SET-ANALYSIS/m-p/222337#M75017 <HTML><HEAD></HEAD><BODY><P>I attach a qvw with data to solve the problem in set analysis</P><P>This is the solution:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 259pt; border-collapse: collapse;" width="344"><COLGROUP><COL style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82" /><COL style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79" /><COL style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" width="49" /><COL style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;" width="52" /><COL style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl26" height="17" style="width: 62pt; height: 12.75pt; background-color: silver; border: #ece9d8;" width="82"><STRONG>MARCA</STRONG></TD><TD class="xl26" style="width: 59pt; background-color: silver; border: #ece9d8;" width="79"><STRONG>MARCA_EQ</STRONG></TD><TD class="xl26" style="width: 37pt; background-color: silver; border: #ece9d8;" width="49"><STRONG>MES</STRONG></TD><TD class="xl26" style="width: 39pt; background-color: silver; border: #ece9d8;" width="52"><STRONG>VALOR</STRONG></TD><TD class="xl26" style="width: 62pt; background-color: silver; border: #ece9d8;" width="82"><STRONG>EXPRESION</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #ece9d8;">FORD</TD><TD class="xl24" style="background-color: yellow; border: #ece9d8;">F100</TD><TD align="right" class="xl24" style="background-color: yellow; border: #ece9d8;">200911</TD><TD align="right" style="background-color: transparent; border: #ece9d8;">10</TD><TD align="right" class="xl24" style="background-color: yellow; border: #ece9d8;">20</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="height: 12.75pt; background-color: yellow; border: #ece9d8;">F100</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl24" style="background-color: yellow; border: #ece9d8;">200911</TD><TD align="right" class="xl24" style="background-color: yellow; border: #ece9d8;">20</TD><TD style="background-color: transparent; border: #ece9d8;"></TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #ece9d8;">FORD</TD><TD class="xl25" style="background-color: #ccffcc; border: #ece9d8;">F100</TD><TD align="right" class="xl25" style="background-color: #ccffcc; border: #ece9d8;">200912</TD><TD align="right" style="background-color: transparent; border: #ece9d8;">15</TD><TD align="right" class="xl25" style="background-color: #ccffcc; border: #ece9d8;">25</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="height: 12.75pt; background-color: #ccffcc; border: #ece9d8;">F100</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="background-color: #ccffcc; border: #ece9d8;">200912</TD><TD align="right" class="xl25" style="background-color: #ccffcc; border: #ece9d8;">25</TD><TD style="background-color: transparent; border: #ece9d8;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>I hope you can help</P><P>Thanks a lot.</P><P></P><P></P></BODY></HTML> Tue, 26 Jan 2010 14:37:44 GMT https://community.qlik.com/t5/QlikView/How-can-I-solve-this-problem-in-SET-ANALYSIS/m-p/222337#M75017 2010-01-26T14:37:44Z