topic Re: In Pivot Table - Set Analysis for two weeks with multiple values in QlikView https://community.qlik.com/t5/QlikView/In-Pivot-Table-Set-Analysis-for-two-weeks-with-multiple-values/m-p/784585#M277687 <HTML><HEAD></HEAD><BODY><P>Please find the screenshot &amp; the required dashboard is like below</P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74134_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 24 Dec 2014 10:18:21 GMT 2014-12-24T10:18:21Z In Pivot Table - Set Analysis for two weeks with multiple values https://community.qlik.com/t5/QlikView/In-Pivot-Table-Set-Analysis-for-two-weeks-with-multiple-values/m-p/784583#M277685 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How to achieve having three columns in one dimension &amp; also to implement Set Analysis for two weeks.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 448px;"><TBODY><TR><TD height="20" width="64"></TD><TD class="xl64" colspan="3" style="border-right: .5pt solid black;" width="192"><STRONG>Current Week</STRONG></TD><TD class="xl64" colspan="3" style="border-right: .5pt solid black; border-left: none;" width="192"><STRONG>Previous Week</STRONG></TD></TR><TR><TD height="20">CUST001</TD><TD align="right" class="xl63" style="border-top: none;">100</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2000</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD></TR><TR><TD height="20">CUST002</TD><TD align="right" class="xl63" style="border-top: none;">50</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1000</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">900</TD></TR><TR><TD height="20">CUST003</TD><TD align="right" class="xl63" style="border-top: none;">200</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3000</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">8</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">900</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">850</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 24 Dec 2014 09:38:37 GMT https://community.qlik.com/t5/QlikView/In-Pivot-Table-Set-Analysis-for-two-weeks-with-multiple-values/m-p/784583#M277685 2014-12-24T09:38:37Z Re: In Pivot Table - Set Analysis for two weeks with multiple values https://community.qlik.com/t5/QlikView/In-Pivot-Table-Set-Analysis-for-two-weeks-with-multiple-values/m-p/784584#M277686 <HTML><HEAD></HEAD><BODY><P>To begin with you need a date field that can be used to determine the current and previous week. The data you posted does not seem to contain such a field. </P></BODY></HTML> Wed, 24 Dec 2014 10:01:17 GMT https://community.qlik.com/t5/QlikView/In-Pivot-Table-Set-Analysis-for-two-weeks-with-multiple-values/m-p/784584#M277686 Gysbert_Wassenaar 2014-12-24T10:01:17Z Re: In Pivot Table - Set Analysis for two weeks with multiple values https://community.qlik.com/t5/QlikView/In-Pivot-Table-Set-Analysis-for-two-weeks-with-multiple-values/m-p/784585#M277687 <HTML><HEAD></HEAD><BODY><P>Please find the screenshot &amp; the required dashboard is like below</P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74134_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 24 Dec 2014 10:18:21 GMT https://community.qlik.com/t5/QlikView/In-Pivot-Table-Set-Analysis-for-two-weeks-with-multiple-values/m-p/784585#M277687 2014-12-24T10:18:21Z