topic Create Pivot Table to compare 2 Dimensions and according mark Status in QlikView https://community.qlik.com/t5/QlikView/Create-Pivot-Table-to-compare-2-Dimensions-and-according-mark/m-p/564787#M210808 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I need to create Pivot that table that would compare in two dimensions and update Status for each Run ( Pass, Fail, No Run )</P><P></P><P>Also Pass filled with Green Color and Failed with Yellow</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 384px;"><TBODY><TR><TD class="xl63" height="20" width="64"> </TD><TD class="xl64" style="border-left: none;" width="64">Run 1</TD><TD class="xl64" style="border-left: none;" width="64">Run 2</TD><TD class="xl64" style="border-left: none;" width="64">Run 3</TD><TD class="xl64" style="border-left: none;" width="64">Run 4</TD><TD class="xl64" style="border-left: none;" width="64">Run 5</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 1</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 2</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 3</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 4</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 5</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 6</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 7</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 8</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 9</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl66" height="21" style="border-top: none;">Test 10</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD></TR></TBODY></TABLE><P></P><P>Any help would be great.</P><P><BR />BR.</P></BODY></HTML> Wed, 26 Mar 2014 20:51:20 GMT 2014-03-26T20:51:20Z Create Pivot Table to compare 2 Dimensions and according mark Status https://community.qlik.com/t5/QlikView/Create-Pivot-Table-to-compare-2-Dimensions-and-according-mark/m-p/564787#M210808 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I need to create Pivot that table that would compare in two dimensions and update Status for each Run ( Pass, Fail, No Run )</P><P></P><P>Also Pass filled with Green Color and Failed with Yellow</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 384px;"><TBODY><TR><TD class="xl63" height="20" width="64"> </TD><TD class="xl64" style="border-left: none;" width="64">Run 1</TD><TD class="xl64" style="border-left: none;" width="64">Run 2</TD><TD class="xl64" style="border-left: none;" width="64">Run 3</TD><TD class="xl64" style="border-left: none;" width="64">Run 4</TD><TD class="xl64" style="border-left: none;" width="64">Run 5</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 1</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 2</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 3</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 4</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 5</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 6</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 7</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 8</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Test 9</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD></TR><TR><TD class="xl66" height="21" style="border-top: none;">Test 10</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl67" style="border-top: none; border-left: none;">Pass</TD><TD class="xl68" style="border-top: none; border-left: none;">Fail</TD></TR></TBODY></TABLE><P></P><P>Any help would be great.</P><P><BR />BR.</P></BODY></HTML> Wed, 26 Mar 2014 20:51:20 GMT https://community.qlik.com/t5/QlikView/Create-Pivot-Table-to-compare-2-Dimensions-and-according-mark/m-p/564787#M210808 2014-03-26T20:51:20Z