topic Re: Totals and % totals in Qlikview straight table in QlikView

topic Re: Totals and % totals in Qlikview straight table in QlikView https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318055#M825523 <HTML><HEAD></HEAD><BODY><P>If i use new expressions, i am getting out put like this.</P><P><IMG __jive_id="170524" alt="Capture23.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170524_Capture23.PNG" style="height: 155px; width: 620px;" /></P><P></P><P>But i  need output like this, I need both the rows Total and '% of Total'</P><P></P><P><IMG __jive_id="170528" alt="Capture24.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/170528_Capture24.PNG" style="height: 116px; width: 620px;" /></P><P></P><P></P><P>Thanks,</P><P>Ganesh</P></BODY></HTML> Tue, 18 Jul 2017 10:24:51 GMT ganeshreddy 2017-07-18T10:24:51Z Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318046#M825508 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Is there any way around to show totals and % of totals in straight table as shown in below image</P><P><IMG alt="test.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170370_test.PNG" style="height: 127px; width: 620px;" /></P><P></P><P>Can any one help.</P><P></P><P>Thanks,</P><P>Ganesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318046#M825508 ganeshreddy 2020-11-25T16:16:04Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318047#M825513 <HTML><HEAD></HEAD><BODY><P>see attached file,</P><P></P><P>hope this helps</P></BODY></HTML> Mon, 17 Jul 2017 09:46:25 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318047#M825513 Frank_Hartmann 2017-07-17T09:46:25Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318048#M825515 <HTML><HEAD></HEAD><BODY><P>Hi Frank,</P><P></P><P>I can not open the qvw files, could you please share any useful community links.</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 17 Jul 2017 09:56:51 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318048#M825515 ganeshreddy 2017-07-17T09:56:51Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318049#M825516 <HTML><HEAD></HEAD><BODY><P>Skript:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_1500285632315662 jive_text_macro" jivemacro_uid="_1500285632315662"> <P>LOAD * INLINE [</P> <P>    Dim</P> <P>    1</P> <P>    2</P> <P>];</P> <P></P> <P></P> <P>LOAD * INLINE [</P> <P>    Customer, Progress, Open, No Response, Waiting, Canceled</P> <P>    Ben, 1, 1, 6, 3, 1</P> <P>    Kevin, 0, 0, 3, 2, 1</P> <P>    Rob, 0, 1, 2, 1, 0</P> <P>    Bob, 0, 0, 1, 2, 1</P> <P>    Steve, 1, 2, 2, 1, 0</P> <P>];</P> </PRE><P></P><P></P><P>As dimension in your straight table use:</P><P>=Pick(Dim,Customer,'% of Total')</P><P></P><P>Expressions:</P><P>if(Pick(Dim,Customer,'% of Total')='% of Total',</P><P>num(sum(Canceled)/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'), </P><P>sum(Canceled))</P><P></P><P>if(Pick(Dim,Customer,'% of Total')='% of Total',</P><P>num(sum(Progress)/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'),</P><P>sum(Progress))</P><P></P><P>if(Pick(Dim,Customer,'% of Total')='% of Total',</P><P>num(sum(Open)/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'),</P><P>sum(Open))</P><P></P><P>if(Pick(Dim,Customer,'% of Total')='% of Total',</P><P>num(sum(Waiting)/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'),</P><P>sum(Waiting))</P><P></P><P>if(Pick(Dim,Customer,'% of Total')='% of Total',</P><P>num(sum([No Response])/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'),</P><P>sum([No Response]))</P><P></P><P>if(Pick(Dim,Customer,'% of Total')='% of Total',</P><P>num(Column(1)+Column(2)+Column(3)+Column(4)+Column(5),'###%'),</P><P>Column(1)+Column(2)+Column(3)+Column(4)+Column(5))</P><P></P><P>hope this helps</P></BODY></HTML> Mon, 17 Jul 2017 10:01:46 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318049#M825516 Frank_Hartmann 2017-07-17T10:01:46Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318050#M825518 <HTML><HEAD></HEAD><BODY><P>and for sorting use this expression:</P><P></P><P>only({1}Dim)  --> Ascending</P></BODY></HTML> Mon, 17 Jul 2017 10:04:15 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318050#M825518 Frank_Hartmann 2017-07-17T10:04:15Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318051#M825519 <HTML><HEAD></HEAD><BODY><P>Do you have any further questions?</P><P>If not, then please close this thread by marking correct and helpful answers</P><P></P><P><A href="https://community.qlik.com/message/1283746">Re: How to mark Helpful or correct reply?</A></P></BODY></HTML> Tue, 18 Jul 2017 08:19:06 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318051#M825519 Frank_Hartmann 2017-07-18T08:19:06Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318052#M825520 <HTML><HEAD></HEAD><BODY><P>Thanks for the valuable reply, but total count row is missing form your example how to get that?</P><P></P><P>and also % symbol is missing form my % of total rows. FYI I am using 'dimensionality()=0' instead <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Pick(Dim,Customer,'% of Total')='% of Total',</SPAN>   </P><P></P><P></P><P>Thanks,</P><P>Ganesh</P></BODY></HTML> Tue, 18 Jul 2017 09:56:43 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318052#M825520 ganeshreddy 2017-07-18T09:56:43Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318053#M825521 <HTML><HEAD></HEAD><BODY><P>I have above mentioned question on</P><P> '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">total count row is missing form your example how to get that?</SPAN>'</P><P></P><P>sure if i am clear, will close the thread.</P><P></P><P>Thanks,</P><P>Ganesh</P></BODY></HTML> Tue, 18 Jul 2017 10:09:16 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318053#M825521 ganeshreddy 2017-07-18T10:09:16Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318054#M825522 <HTML><HEAD></HEAD><BODY><P>Ok, here the adapted solution:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15003721685791284 jive_text_macro" jivemacro_uid="_15003721685791284" modifiedtitle="true"> <P>LOAD * INLINE [</P> <P>    Dim</P> <P>    1</P> <P>    2</P> <P>];</P> <P></P> <P>LOAD * INLINE [</P> <P>    Customer, Progress, Open, No Response, Waiting, Canceled</P> <P>    Ben, 1, 1, 6, 3, 1</P> <P>    Kevin, 0, 0, 3, 2, 1</P> <P>    Rob, 0, 1, 2, 1, 0</P> <P>    Bob, 0, 0, 1, 2, 1</P> <P>    Steve, 1, 2, 2, 1, 0</P> <P>Ok];</P> </PRE><P></P><P>Dimension:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15003724378648915" jivemacro_uid="_15003724378648915"> <P>=Pick(Dim,Customer,'Total')</P> </PRE><P></P><P>Expression 1 for <STRONG>canceled</STRONG>:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15003722983946777" jivemacro_uid="_15003722983946777"> <P>if(Dimensionality()=0,</P> <P>num(sum(Canceled)/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'), </P> <P>sum(Canceled))</P> </PRE><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Expression 2 for <STRONG>progress</STRONG>:</SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15003723229248218" jivemacro_uid="_15003723229248218"> <P>if(Dimensionality()=0,</P> <P>num(sum(Progress)/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'),</P> <P>sum(Progress))</P> </PRE><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Expression 3 for <STRONG>open</STRONG>:</SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1500372342964678" jivemacro_uid="_1500372342964678"> <P>if(Dimensionality()=0,</P> <P>num(sum(Open)/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'),</P> <P>sum(Open))</P> </PRE><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Expression 4 for<STRONG> no response</STRONG>:</SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15003723652929748 jive_text_macro" jivemacro_uid="_15003723652929748"> <P>if(Dimensionality()=0,</P> <P>num(sum(Waiting)/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'),</P> <P>sum(Waiting))</P> </PRE><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Expression 5 for <STRONG>waiting</STRONG>:</SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15003723846839689" jivemacro_uid="_15003723846839689"> <P>if(Dimensionality()=0,</P> <P>num(sum([No Response])/(sum(Canceled)+sum(Progress)+sum(Open)+sum([No Response])+sum(Waiting)),'##%'),</P> <P>sum([No Response]))</P> </PRE><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Expression 6 for <STRONG>TOTAL</STRONG>:</SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15003724027885651 jive_text_macro" jivemacro_uid="_15003724027885651"> <P>if(Dimensionality()=0,</P> <P>num(Column(1)+Column(2)+Column(3)+Column(4)+Column(5),'###%'),</P> <P>Column(1)+Column(2)+Column(3)+Column(4)+Column(5))</P> </PRE><P></P><P></P><P>And this is my Output:</P><P><IMG alt="Unbenannt.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170527_Unbenannt.png" style="height: 107px; width: 620px;" /></P><P></P><P>hope this helps!</P></BODY></HTML> Tue, 18 Jul 2017 10:10:38 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318054#M825522 Frank_Hartmann 2017-07-18T10:10:38Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318055#M825523 <HTML><HEAD></HEAD><BODY><P>If i use new expressions, i am getting out put like this.</P><P><IMG __jive_id="170524" alt="Capture23.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170524_Capture23.PNG" style="height: 155px; width: 620px;" /></P><P></P><P>But i  need output like this, I need both the rows Total and '% of Total'</P><P></P><P><IMG __jive_id="170528" alt="Capture24.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/170528_Capture24.PNG" style="height: 116px; width: 620px;" /></P><P></P><P></P><P>Thanks,</P><P>Ganesh</P></BODY></HTML> Tue, 18 Jul 2017 10:24:51 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318055#M825523 ganeshreddy 2017-07-18T10:24:51Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318056#M825524 <HTML><HEAD></HEAD><BODY><P>sort tab:</P><P>---> customer: Expression: <STRONG>only({1}Dim)</STRONG> (ascending)</P><P></P><P>presentation tab:</P><P>---> Totals: Totals on last Row (use Label activate: <STRONG>% of Total)</STRONG></P></BODY></HTML> Tue, 18 Jul 2017 10:32:28 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318056#M825524 Frank_Hartmann 2017-07-18T10:32:28Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318057#M825525 <HTML><HEAD></HEAD><BODY><P>what do you mean by total count?</P><P>Expression 6 is for Total, isnt it?</P></BODY></HTML> Tue, 18 Jul 2017 10:34:17 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318057#M825525 Frank_Hartmann 2017-07-18T10:34:17Z Re: Totals and % totals in Qlikview straight table https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318058#M825526 <HTML><HEAD></HEAD><BODY><P>Thank you Frank..:)</P></BODY></HTML> Wed, 19 Jul 2017 07:48:32 GMT https://community.qlik.com/t5/QlikView/Totals-and-totals-in-Qlikview-straight-table/m-p/1318058#M825526 ganeshreddy 2017-07-19T07:48:32Z