https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1707234#M63899 <P>Great. Then please like the answer and mark it as solution.&nbsp;</P><P>-Rob</P> Mon, 01 Jun 2020 19:27:17 GMT rwunderlich 2020-06-01T19:27:17Z https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1706616#M63896 <P>Hi All,</P><P>I am new to Qlik sense and while working on Qlik I am stuck in one point where I want to calculate % of Downtime ?</P><TABLE width="275"><TBODY><TR><TD width="42">Name</TD><TD width="67">Time</TD><TD width="68">Downtime</TD><TD width="98">% of Downtime</TD></TR><TR><TD>A</TD><TD>Morning</TD><TD>2</TD><TD>25%</TD></TR><TR><TD>A</TD><TD>Afternoon</TD><TD>0.5</TD><TD>6%</TD></TR><TR><TD>A</TD><TD>Evening</TD><TD>1.5</TD><TD>19%</TD></TR><TR><TD>A</TD><TD>Night</TD><TD>4</TD><TD>50%</TD></TR><TR><TD>B</TD><TD>Afternoon</TD><TD>2</TD><TD>31%</TD></TR><TR><TD>B</TD><TD>Evening</TD><TD>1.5</TD><TD>23%</TD></TR><TR><TD>B</TD><TD>Night</TD><TD>3</TD><TD>46%</TD></TR><TR><TD>C</TD><TD>Morning</TD><TD>5</TD><TD>63%</TD></TR><TR><TD>C</TD><TD>Afternoon</TD><TD>2</TD><TD>25%</TD></TR><TR><TD>C</TD><TD>Evening</TD><TD>1</TD><TD>13%</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 18:34:14 GMT https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1706616#M63896 Biswa88 2024-11-16T18:34:14Z https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1706684#M63897 <P>I assume % is the percent of the "Name" group. If so, then the expression to calculate ratio within the Name is:</P><P class="p1"><FONT face="courier new,courier"><SPAN class="s1">Sum</SPAN><SPAN class="s2">(</SPAN>Downtime<SPAN class="s2">) / </SPAN><SPAN class="s1">sum</SPAN><SPAN class="s2">(</SPAN><SPAN class="s1">TOTAL</SPAN><SPAN class="s2">&lt;</SPAN>Name<SPAN class="s2">&gt; </SPAN>Downtime<SPAN class="s2">) </SPAN></FONT></P><P class="p1"><SPAN class="s2">-Rob<BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A><BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A></SPAN></P> Fri, 29 May 2020 21:13:33 GMT https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1706684#M63897 rwunderlich 2020-05-29T21:13:33Z https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1707076#M63898 <P>Thanks Rob. It worked.&nbsp;</P> Mon, 01 Jun 2020 10:36:52 GMT https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1707076#M63898 Biswa88 2020-06-01T10:36:52Z https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1707234#M63899 <P>Great. Then please like the answer and mark it as solution.&nbsp;</P><P>-Rob</P> Mon, 01 Jun 2020 19:27:17 GMT https://community.qlik.com/t5/App-Development/Row-level-in-Qliksense/m-p/1707234#M63899 rwunderlich 2020-06-01T19:27:17Z