topic Pivot table with range dimension in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-with-range-dimension/m-p/372430#M576348 <HTML><HEAD></HEAD><BODY><P>Hi Dear comunity</P><P></P><P>I need made a Pivot table with a range dimension. This is the original datatable</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="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Age</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Class</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubClass</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>10</TD><TD>A</TD><TD>A1</TD><TD>100</TD></TR><TR><TD>20</TD><TD>A</TD><TD>A2</TD><TD>200</TD></TR><TR><TD>30</TD><TD>C</TD><TD>C2</TD><TD>300</TD></TR><TR><TD>60</TD><TD>D</TD><TD>D1</TD><TD>400</TD></TR><TR><TD>90</TD><TD>F</TD><TD>F2</TD><TD>500</TD></TR></TBODY></TABLE><P></P><P>The desired pivot table is:</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="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Range (Age)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value (Sum (Value))</STRONG></SPAN></TH></TR><TR><TD>From 0 to 15</TD><TD>100</TD></TR><TR><TD>From 16 to 30</TD><TD>500</TD></TR><TR><TD>Up to 31</TD><TD>900</TD></TR></TBODY></TABLE><P></P><P>Thanks !!</P></BODY></HTML> Fri, 27 Apr 2012 18:19:46 GMT 2012-04-27T18:19:46Z Pivot table with range dimension https://community.qlik.com/t5/QlikView/Pivot-table-with-range-dimension/m-p/372430#M576348 <HTML><HEAD></HEAD><BODY><P>Hi Dear comunity</P><P></P><P>I need made a Pivot table with a range dimension. This is the original datatable</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="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Age</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Class</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubClass</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>10</TD><TD>A</TD><TD>A1</TD><TD>100</TD></TR><TR><TD>20</TD><TD>A</TD><TD>A2</TD><TD>200</TD></TR><TR><TD>30</TD><TD>C</TD><TD>C2</TD><TD>300</TD></TR><TR><TD>60</TD><TD>D</TD><TD>D1</TD><TD>400</TD></TR><TR><TD>90</TD><TD>F</TD><TD>F2</TD><TD>500</TD></TR></TBODY></TABLE><P></P><P>The desired pivot table is:</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="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Range (Age)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value (Sum (Value))</STRONG></SPAN></TH></TR><TR><TD>From 0 to 15</TD><TD>100</TD></TR><TR><TD>From 16 to 30</TD><TD>500</TD></TR><TR><TD>Up to 31</TD><TD>900</TD></TR></TBODY></TABLE><P></P><P>Thanks !!</P></BODY></HTML> Fri, 27 Apr 2012 18:19:46 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-range-dimension/m-p/372430#M576348 2012-04-27T18:19:46Z Pivot table with range dimension https://community.qlik.com/t5/QlikView/Pivot-table-with-range-dimension/m-p/372431#M576349 <HTML><HEAD></HEAD><BODY><P>Check out this thread/answer:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/213862#213862">http://community.qlik.com/message/213862#213862</A></P></BODY></HTML> Fri, 27 Apr 2012 19:03:30 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-range-dimension/m-p/372431#M576349 Nicole-Smith 2012-04-27T19:03:30Z Pivot table with range dimension https://community.qlik.com/t5/QlikView/Pivot-table-with-range-dimension/m-p/372432#M576350 <HTML><HEAD></HEAD><BODY><P>Just use some nested if statements to set it up however you want.</P><P></P><P>If(Age&lt;=15,'From 0 to 15',if(Age&lt;=30,'From 16 to 30','Up to 31')) would work for your dimension. The expression would just be sum(value)</P></BODY></HTML> Fri, 27 Apr 2012 19:16:44 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-range-dimension/m-p/372432#M576350 danielact 2012-04-27T19:16:44Z