topic Incidence in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Incidence-in-Pivot-table/m-p/345546#M494613 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Hi, </SPAN></P><P><SPAN style="font-size: 12pt;">in a pivot table I have to divide all the possible values (val2) of a dimension (dim1) by the same amount (tot1, Header4) that is the total of the other possible values (val1) of the same dimension </SPAN><SPAN style="font-size: 12pt;">in order to obtain the incidence on the total (total1).</SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></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"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 4</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 5</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 6</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 7</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 8</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 9</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 10</STRONG></SPAN></TH></TR><TR><TD>dim1</TD><TD>val1</TD><TD>val1</TD><TD>tot1</TD><TD>val2</TD><TD>val2</TD><TD>tot2</TD><TD><SPAN style="color: #0000ff;"><STRONG>incid</STRONG></SPAN></TD><TD><SPAN style="color: #0000ff;"><STRONG>incid</STRONG></SPAN></TD><TD></TD></TR><TR><TD><P>dim2</P></TD><TD>20</TD><TD>30</TD><TD><P><STRONG>50</STRONG></P></TD><TD><P><SPAN style="color: #ff0000;"><STRONG>15</STRONG></SPAN></P></TD><TD><SPAN style="color: #ff0000;"><STRONG>35</STRONG></SPAN></TD><TD><SPAN style="color: #000000;">50</SPAN></TD><TD><STRONG style="color: #0000ff;">15/50</STRONG></TD><TD><STRONG style="color: #0000ff;">35/50</STRONG></TD><TD></TD></TR><TR><TD><SPAN style="color: #000000;">dim2</SPAN></TD><TD><SPAN style="color: #000000;">10</SPAN></TD><TD><SPAN style="color: #000000;">15</SPAN></TD><TD><STRONG style="color: #000000;">25</STRONG></TD><TD><SPAN style="color: #ff0000;"><STRONG>10</STRONG></SPAN></TD><TD><SPAN style="color: #ff0000;"><STRONG>25</STRONG></SPAN></TD><TD><SPAN style="color: #000000;">35</SPAN></TD><TD><SPAN style="color: #0000ff;"><STRONG>10/25</STRONG></SPAN></TD><TD><SPAN style="color: #0000ff;"><STRONG>25/25</STRONG></SPAN></TD><TD></TD></TR><TR><TD><SPAN style="color: #000000;">tot</SPAN></TD><TD><SPAN style="color: #000000;">30</SPAN></TD><TD><SPAN style="color: #000000;">45</SPAN></TD><TD><STRONG style="color: #000000;">75</STRONG></TD><TD><SPAN style="color: #ff0000;"><STRONG>25</STRONG></SPAN></TD><TD><SPAN style="color: #ff0000;"><STRONG>60</STRONG></SPAN></TD><TD><SPAN style="color: #000000;">85</SPAN></TD><TD><STRONG style="color: #0000ff;">25/75</STRONG></TD><TD><STRONG style="color: #0000ff;">60/75</STRONG></TD><TD></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;"></SPAN></P><P><SPAN style="font-size: 12pt;">the possible values are defined as Sum(field) </SPAN></P><P></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt; text-decoration: underline;"> </SPAN></P><P><SPAN style="font-size: 12pt; text-decoration: underline;"> </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="text-decoration: underline;">In attached xls</SPAN>: blue columns are the "incidence"... yellow column is the total (denominator) and orange ones the numerator.</SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;">Thanks</SPAN></P><P><SPAN style="font-size: 12pt;">EP</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">How can I do?</SPAN></P></BODY></HTML> Fri, 09 Mar 2012 15:25:47 GMT 2012-03-09T15:25:47Z Incidence in Pivot table https://community.qlik.com/t5/QlikView/Incidence-in-Pivot-table/m-p/345546#M494613 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Hi, </SPAN></P><P><SPAN style="font-size: 12pt;">in a pivot table I have to divide all the possible values (val2) of a dimension (dim1) by the same amount (tot1, Header4) that is the total of the other possible values (val1) of the same dimension </SPAN><SPAN style="font-size: 12pt;">in order to obtain the incidence on the total (total1).</SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></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"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 4</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 5</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 6</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 7</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 8</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 9</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 10</STRONG></SPAN></TH></TR><TR><TD>dim1</TD><TD>val1</TD><TD>val1</TD><TD>tot1</TD><TD>val2</TD><TD>val2</TD><TD>tot2</TD><TD><SPAN style="color: #0000ff;"><STRONG>incid</STRONG></SPAN></TD><TD><SPAN style="color: #0000ff;"><STRONG>incid</STRONG></SPAN></TD><TD></TD></TR><TR><TD><P>dim2</P></TD><TD>20</TD><TD>30</TD><TD><P><STRONG>50</STRONG></P></TD><TD><P><SPAN style="color: #ff0000;"><STRONG>15</STRONG></SPAN></P></TD><TD><SPAN style="color: #ff0000;"><STRONG>35</STRONG></SPAN></TD><TD><SPAN style="color: #000000;">50</SPAN></TD><TD><STRONG style="color: #0000ff;">15/50</STRONG></TD><TD><STRONG style="color: #0000ff;">35/50</STRONG></TD><TD></TD></TR><TR><TD><SPAN style="color: #000000;">dim2</SPAN></TD><TD><SPAN style="color: #000000;">10</SPAN></TD><TD><SPAN style="color: #000000;">15</SPAN></TD><TD><STRONG style="color: #000000;">25</STRONG></TD><TD><SPAN style="color: #ff0000;"><STRONG>10</STRONG></SPAN></TD><TD><SPAN style="color: #ff0000;"><STRONG>25</STRONG></SPAN></TD><TD><SPAN style="color: #000000;">35</SPAN></TD><TD><SPAN style="color: #0000ff;"><STRONG>10/25</STRONG></SPAN></TD><TD><SPAN style="color: #0000ff;"><STRONG>25/25</STRONG></SPAN></TD><TD></TD></TR><TR><TD><SPAN style="color: #000000;">tot</SPAN></TD><TD><SPAN style="color: #000000;">30</SPAN></TD><TD><SPAN style="color: #000000;">45</SPAN></TD><TD><STRONG style="color: #000000;">75</STRONG></TD><TD><SPAN style="color: #ff0000;"><STRONG>25</STRONG></SPAN></TD><TD><SPAN style="color: #ff0000;"><STRONG>60</STRONG></SPAN></TD><TD><SPAN style="color: #000000;">85</SPAN></TD><TD><STRONG style="color: #0000ff;">25/75</STRONG></TD><TD><STRONG style="color: #0000ff;">60/75</STRONG></TD><TD></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;"></SPAN></P><P><SPAN style="font-size: 12pt;">the possible values are defined as Sum(field) </SPAN></P><P></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt; text-decoration: underline;"> </SPAN></P><P><SPAN style="font-size: 12pt; text-decoration: underline;"> </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="text-decoration: underline;">In attached xls</SPAN>: blue columns are the "incidence"... yellow column is the total (denominator) and orange ones the numerator.</SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;">Thanks</SPAN></P><P><SPAN style="font-size: 12pt;">EP</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">How can I do?</SPAN></P></BODY></HTML> Fri, 09 Mar 2012 15:25:47 GMT https://community.qlik.com/t5/QlikView/Incidence-in-Pivot-table/m-p/345546#M494613 2012-03-09T15:25:47Z