topic Expression in Pivot - help in QlikView

topic Expression in Pivot - help in QlikView https://community.qlik.com/t5/QlikView/Expression-in-Pivot-help/m-p/85200#M770559 <HTML><HEAD></HEAD><BODY><P>Hello all</P><P></P><P>I am tying to calculate <=1 day, 2 days and > 2 days as percentage.</P><P></P><P>from this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD height="20" width="64"></TD><TD width="64">Jan</TD><TD width="64">Feb</TD><TD width="64">Mar</TD></TR><TR><TD height="20"><=1 day</TD><TD align="right">15</TD><TD align="right">20</TD><TD align="right">34</TD></TR><TR><TD height="20">2 days</TD><TD align="right">8</TD><TD align="right">16</TD><TD align="right">12</TD></TR><TR><TD height="20">> 2 days</TD><TD align="right">1</TD><TD align="right">6</TD><TD align="right">10</TD></TR><TR><TD height="20">Total</TD><TD align="right">24</TD><TD align="right">42</TD><TD align="right">56</TD></TR></TBODY></TABLE><P></P><P>To show this</P><P></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD height="20" width="64"></TD><TD width="64">Jan</TD><TD width="64">Feb</TD><TD width="64">Mar</TD></TR><TR><TD height="20"><=1 day</TD><TD align="right" class="xl65">63%</TD><TD align="right" class="xl65">48%</TD><TD align="right" class="xl65">61%</TD></TR><TR><TD height="20">2 days</TD><TD align="right" class="xl65">33%</TD><TD align="right" class="xl65">38%</TD><TD align="right" class="xl65">21%</TD></TR><TR><TD height="20">> 2 days</TD><TD align="right" class="xl65">4%</TD><TD align="right" class="xl65">14%</TD><TD align="right" class="xl65">18%</TD></TR><TR><TD height="20">Total</TD><TD align="right" class="xl66">100%</TD><TD align="right" class="xl66">100%</TD><TD align="right" class="xl66">100%</TD></TR></TBODY></TABLE><P></P><P>Any help would be appreciated.</P><P></P><P>Regards</P><P>Mohi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mohiahmed 2020-11-25T16:16:04Z Expression in Pivot - help https://community.qlik.com/t5/QlikView/Expression-in-Pivot-help/m-p/85200#M770559 <HTML><HEAD></HEAD><BODY><P>Hello all</P><P></P><P>I am tying to calculate <=1 day, 2 days and > 2 days as percentage.</P><P></P><P>from this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD height="20" width="64"></TD><TD width="64">Jan</TD><TD width="64">Feb</TD><TD width="64">Mar</TD></TR><TR><TD height="20"><=1 day</TD><TD align="right">15</TD><TD align="right">20</TD><TD align="right">34</TD></TR><TR><TD height="20">2 days</TD><TD align="right">8</TD><TD align="right">16</TD><TD align="right">12</TD></TR><TR><TD height="20">> 2 days</TD><TD align="right">1</TD><TD align="right">6</TD><TD align="right">10</TD></TR><TR><TD height="20">Total</TD><TD align="right">24</TD><TD align="right">42</TD><TD align="right">56</TD></TR></TBODY></TABLE><P></P><P>To show this</P><P></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD height="20" width="64"></TD><TD width="64">Jan</TD><TD width="64">Feb</TD><TD width="64">Mar</TD></TR><TR><TD height="20"><=1 day</TD><TD align="right" class="xl65">63%</TD><TD align="right" class="xl65">48%</TD><TD align="right" class="xl65">61%</TD></TR><TR><TD height="20">2 days</TD><TD align="right" class="xl65">33%</TD><TD align="right" class="xl65">38%</TD><TD align="right" class="xl65">21%</TD></TR><TR><TD height="20">> 2 days</TD><TD align="right" class="xl65">4%</TD><TD align="right" class="xl65">14%</TD><TD align="right" class="xl65">18%</TD></TR><TR><TD height="20">Total</TD><TD align="right" class="xl66">100%</TD><TD align="right" class="xl66">100%</TD><TD align="right" class="xl66">100%</TD></TR></TBODY></TABLE><P></P><P>Any help would be appreciated.</P><P></P><P>Regards</P><P>Mohi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-in-Pivot-help/m-p/85200#M770559 mohiahmed 2020-11-25T16:16:04Z