topic Re: Qlik Sense Pivot with percentages in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-with-percentages/m-p/1048860#M16494 <HTML><HEAD></HEAD><BODY><P>Hi Sunny T</P><P></P><P>I have the following excel with the rawdata and the mockup dashboard as it should look like.</P><P>Best regards</P></BODY></HTML> Mon, 18 Apr 2016 08:47:31 GMT 2016-04-18T08:47:31Z Qlik Sense Pivot with percentages https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-with-percentages/m-p/1048858#M16492 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have the following table with the rawdata:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1017px;"><TBODY><TR><TD class="xl80" height="21" width="80">NR</TD><TD class="xl80" width="80">Project</TD><TD class="xl80" width="80">Task</TD><TD class="xl80" width="81">KST</TD><TD class="xl80" width="100">KOA</TD><TD class="xl75" width="68">ID</TD><TD class="xl75" width="167">Description</TD><TD class="xl75" width="81">Status</TD><TD class="xl75" width="89">Assignee</TD><TD class="xl75" width="90">Risk Level</TD><TD class="xl76" width="101">Deadline</TD></TR><TR><TD class="xl74" height="21"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD align="right" class="xl77">1</TD><TD class="xl77">API Design 2</TD><TD class="xl77">Closed</TD><TD class="xl77">John</TD><TD class="xl79" style="font-size: 12.0pt; color: #3f3f76; font-weight: 400; font-family: Calibri; border: .5pt solid #7f7f7f; background: #FABF8F;">Medium</TD><TD align="right" class="xl78">18.09.2016</TD></TR><TR><TD class="xl74" height="21"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD align="right" class="xl77">2</TD><TD class="xl77">API Development 2</TD><TD class="xl77">Behind</TD><TD class="xl77">Martha</TD><TD class="xl79" style="border-top: none; font-size: 12.0pt; color: #3f3f76; font-weight: 400; font-family: Calibri; border: .5pt solid #7f7f7f; background: #DAEEF3;">Low</TD><TD align="right" class="xl78">31.08.2016</TD></TR><TR><TD class="xl74" height="21"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD class="xl74"></TD><TD align="right" class="xl77">3</TD><TD class="xl77">API Testing 1</TD><TD class="xl77">Work in Progress</TD><TD class="xl77">Jill </TD><TD class="xl79" style="border-top: none; font-size: 12.0pt; color: #9c0006; font-weight: 400; font-family: Calibri; border: .5pt solid #7f7f7f; background: #DA9694;">High</TD><TD align="right" class="xl78">14.07.2016</TD></TR></TBODY></TABLE><P></P><P>and I need to produce the following pivot:<BR />&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="656"><TBODY><TR><TD class="xl90" height="21" width="80">Task Status/Priority</TD><TD class="xl91" width="80"> </TD><TD class="xl78" width="80">High</TD><TD class="xl79" style="border-left: none;" width="81">Medium</TD><TD class="xl80" width="100">Low</TD><TD class="xl81" width="68">Total</TD><TD class="xl82" width="167">% of Total</TD></TR><TR><TD class="xl92" height="21" style="border-top: none;">Closed</TD><TD class="xl92" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl83" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl84" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl85" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl86" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl87" style="border-top: none; border-left: none;">25%</TD></TR><TR><TD class="xl92" height="21" style="border-top: none;">Work in Progress</TD><TD class="xl92" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl83" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl84" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl85" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl86" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl87" style="border-top: none; border-left: none;">50%</TD></TR><TR><TD class="xl92" height="21" style="border-top: none;">Behind</TD><TD class="xl92" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl83" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl84" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl85" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl86" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl87" style="border-top: none; border-left: none;">25%</TD></TR><TR><TD class="xl93" height="22" style="border-top: none;">Not Started</TD><TD class="xl93" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl83" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl84" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl85" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl86" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl87" style="border-top: none; border-left: none;">0%</TD></TR><TR><TD class="xl94" height="23" style="border-top: none;">Total</TD><TD class="xl94" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl88" style="border-left: none;">1</TD><TD align="right" class="xl88" style="border-left: none;">2</TD><TD align="right" class="xl88" style="border-left: none;">1</TD><TD align="right" class="xl88" style="border-left: none;">4</TD><TD align="right" class="xl89" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl77" height="22"> </TD><TD class="xl77"> </TD><TD align="right" class="xl87" style="border-top: none;">25%</TD><TD align="right" class="xl87" style="border-top: none; border-left: none;">50%</TD><TD align="right" class="xl87" style="border-top: none; border-left: none;">25%</TD><TD align="right" class="xl87" style="border-top: none; border-left: none;">100%</TD><TD align="right" class="xl77" style="font-size: 12.0pt; color: black; font-weight: 400; font-family: 'Roboto Light'; border: none; background: red;">6.25</TD></TR></TBODY></TABLE><P></P><P>Any Ideas how to achieve a pivot with percentages?</P><P></P><P>Thanx and best regards</P></BODY></HTML> Mon, 18 Apr 2016 08:03:02 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-with-percentages/m-p/1048858#M16492 2016-04-18T08:03:02Z Re: Qlik Sense Pivot with percentages https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-with-percentages/m-p/1048859#M16493 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample?</P></BODY></HTML> Mon, 18 Apr 2016 08:33:35 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-with-percentages/m-p/1048859#M16493 sunny_talwar 2016-04-18T08:33:35Z Re: Qlik Sense Pivot with percentages https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-with-percentages/m-p/1048860#M16494 <HTML><HEAD></HEAD><BODY><P>Hi Sunny T</P><P></P><P>I have the following excel with the rawdata and the mockup dashboard as it should look like.</P><P>Best regards</P></BODY></HTML> Mon, 18 Apr 2016 08:47:31 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-with-percentages/m-p/1048860#M16494 2016-04-18T08:47:31Z