topic Re: set analysis help in QlikView https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/714752#M257198 <HTML><HEAD></HEAD><BODY><P>Attached is the QVW document with the table u asked for. There is a back end script change involved in it. Hope this helps.</P><P></P><P><IMG __jive_id="65970" alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65970_Capture.PNG.png" style="width: 620px; height: 92px;" /></P></BODY></HTML> Thu, 04 Sep 2014 22:43:20 GMT 2014-09-04T22:43:20Z set analysis help https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/714751#M257197 <HTML><HEAD></HEAD><BODY><P>This is what my table looks like currently....what set analysis can I use to make them be side by side?</P><P></P><TABLE border="1" class="jiveBorder" height="73.18181824684143" style="border: 1px solid #000000; font-weight: inherit; font-style: inherit; font-size: 12.727272033691406px; font-family: inherit; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">yr/wk</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">product</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">region</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">sales</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle"><SPAN style="font-size: 8pt;"><STRONG>forecast</STRONG></SPAN></TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR><TD>201236</TD><TD>a</TD><TD>west</TD><TD>175</TD><TD></TD></TR><TR><TD colspan="1">201237</TD><TD colspan="1">b</TD><TD colspan="1">east</TD><TD colspan="1">500</TD><TD colspan="1"></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">201336</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">west</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">200</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"></TD></TR><TR><TD>201337</TD><TD>b</TD><TD>east</TD><TD>400</TD><TD></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">201436</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">west</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">194</TD></TR></TBODY><TBODY><TR><TD>201437</TD><TD>b</TD><TD>east</TD><TD></TD><TD>345</TD></TR></TBODY></TABLE><P></P><P>I would like for them to look like this</P><TABLE border="1" class="jiveBorder" height="73.18181824684143" style="border: 1px solid #000000; font-weight: inherit; font-style: inherit; font-size: 12.727272033691406px; font-family: inherit; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">yr/wk</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">product</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">region</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">sales 2 yr previously (2012 sales)</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle">sales 1 year previously (2013 sales)</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; color: #ffffff; background-color: #6690bc; background-position: no-repeat;" valign="middle"><SPAN style="font-size: 8pt;"><STRONG>forecast</STRONG></SPAN></TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">201436</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">west</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">175</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">200</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">194</TD></TR></TBODY><TBODY><TR><TD>201437</TD><TD>b</TD><TD>east</TD><TD>500</TD><TD>400</TD><TD>345</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 04 Sep 2014 21:58:02 GMT https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/714751#M257197 2014-09-04T21:58:02Z Re: set analysis help https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/714752#M257198 <HTML><HEAD></HEAD><BODY><P>Attached is the QVW document with the table u asked for. There is a back end script change involved in it. Hope this helps.</P><P></P><P><IMG __jive_id="65970" alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65970_Capture.PNG.png" style="width: 620px; height: 92px;" /></P></BODY></HTML> Thu, 04 Sep 2014 22:43:20 GMT https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/714752#M257198 2014-09-04T22:43:20Z