topic format the pivot table in QlikView https://community.qlik.com/t5/QlikView/format-the-pivot-table/m-p/389281#M566756 <HTML><HEAD></HEAD><BODY><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-COLLAPSE: collapse; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="TEXT-ALIGN: center; PADDING-BOTTOM: 3px; PADDING-LEFT: 3px; WIDTH: 1px; PADDING-RIGHT: 3px; FONT-FAMILY: Arial; COLOR: #ffffff; PADDING-TOP: 3px;" valign="top"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH colspan="2" style="TEXT-ALIGN: center; PADDING-BOTTOM: 3px; PADDING-LEFT: 3px; PADDING-RIGHT: 3px; FONT-FAMILY: Arial; COLOR: #ffffff; PADDING-TOP: 3px;" valign="top"><SPAN style="color: #000000;">dimension1Value1</SPAN></TH><TD style="TEXT-ALIGN: center;">dimension1Value2</TD><TD></TD></TR><TR><TD></TD><TD><BR />set analysis1</TD><TD>set analysis2</TD><TD><BR /><P></P><P>set analysis1</P></TD><TD>set analysis2</TD></TR><TR><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">dimension2Value1</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">-</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">90%</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">-</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">90%</TD></TR><TR><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">dimension2Value2</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">80%</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">-</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">70%</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">-</TD></TR></TBODY></TABLE><P></P><P>There're two dimensions:dimension1 and dimension2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; two set analysis:set analysis1,set analysis2</P><P></P><P>Then in the pivot table ,the result is just like the table before.</P><P></P><P>But I want it to show like this :</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="null;" valign="middle"></TH><TH align="center" style="null;" valign="middle"><SPAN style="color: #000000;">dimension1Value1 </SPAN></TH><TH align="center" style="null;" valign="middle"><SPAN style="color: #000000;">dimension1Value2</SPAN></TH></TR><TR><TD>dimension2Value1</TD><TD>90%</TD><TD>90%</TD></TR><TR><TD>dimension2Value2</TD><TD>80%</TD><TD>70%</TD></TR></TBODY></TABLE><P></P><P>Anyone can help?</P><P>Thank you!</P></BODY></HTML> Thu, 29 Nov 2012 03:19:01 GMT 2012-11-29T03:19:01Z format the pivot table https://community.qlik.com/t5/QlikView/format-the-pivot-table/m-p/389281#M566756 <HTML><HEAD></HEAD><BODY><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-COLLAPSE: collapse; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="TEXT-ALIGN: center; PADDING-BOTTOM: 3px; PADDING-LEFT: 3px; WIDTH: 1px; PADDING-RIGHT: 3px; FONT-FAMILY: Arial; COLOR: #ffffff; PADDING-TOP: 3px;" valign="top"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH colspan="2" style="TEXT-ALIGN: center; PADDING-BOTTOM: 3px; PADDING-LEFT: 3px; PADDING-RIGHT: 3px; FONT-FAMILY: Arial; COLOR: #ffffff; PADDING-TOP: 3px;" valign="top"><SPAN style="color: #000000;">dimension1Value1</SPAN></TH><TD style="TEXT-ALIGN: center;">dimension1Value2</TD><TD></TD></TR><TR><TD></TD><TD><BR />set analysis1</TD><TD>set analysis2</TD><TD><BR /><P></P><P>set analysis1</P></TD><TD>set analysis2</TD></TR><TR><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">dimension2Value1</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">-</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">90%</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">-</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">90%</TD></TR><TR><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">dimension2Value2</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">80%</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">-</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">70%</TD><TD style="text-align: left; background-color: transparent; font-family: Arial; color: #000000; padding: 3px;">-</TD></TR></TBODY></TABLE><P></P><P>There're two dimensions:dimension1 and dimension2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; two set analysis:set analysis1,set analysis2</P><P></P><P>Then in the pivot table ,the result is just like the table before.</P><P></P><P>But I want it to show like this :</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="null;" valign="middle"></TH><TH align="center" style="null;" valign="middle"><SPAN style="color: #000000;">dimension1Value1 </SPAN></TH><TH align="center" style="null;" valign="middle"><SPAN style="color: #000000;">dimension1Value2</SPAN></TH></TR><TR><TD>dimension2Value1</TD><TD>90%</TD><TD>90%</TD></TR><TR><TD>dimension2Value2</TD><TD>80%</TD><TD>70%</TD></TR></TBODY></TABLE><P></P><P>Anyone can help?</P><P>Thank you!</P></BODY></HTML> Thu, 29 Nov 2012 03:19:01 GMT https://community.qlik.com/t5/QlikView/format-the-pivot-table/m-p/389281#M566756 2012-11-29T03:19:01Z Re: format the pivot table https://community.qlik.com/t5/QlikView/format-the-pivot-table/m-p/389282#M566757 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P></P><P>Use one expression like this instead of 2 expressions</P><P></P><P>=If(Expression1 &gt;0, Expression1, Expression2)</P><P></P><P>=If(Sum(Sales1) &gt; 0, Sum(Sales1), Sum(Sales2))</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 29 Nov 2012 05:57:57 GMT https://community.qlik.com/t5/QlikView/format-the-pivot-table/m-p/389282#M566757 jagan 2012-11-29T05:57:57Z