topic Re: How to get Breakdowns of Total in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575686#M1119596 <HTML><HEAD></HEAD><BODY><P>Can you upload your reloaded file... The file on which I am working is showing something different and it is difficult to match your requirements.</P></BODY></HTML> Tue, 28 Jan 2014 15:55:48 GMT MK_QSL 2014-01-28T15:55:48Z How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575648#M1119554 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have straight table in attached qvw. I need to show the break down of each Queue. I have Total Queue already created but I would need the Breakdowns which was showing in attached png.</P><P></P><P>could anyone help me by looking into attached please.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 27 Jan 2014 16:11:15 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575648#M1119554 2014-01-27T16:11:15Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575649#M1119555 <HTML><HEAD></HEAD><BODY><P>Is the 'result' field what you need to show as another dimension?</P></BODY></HTML> Mon, 27 Jan 2014 16:36:29 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575649#M1119555 Anonymous 2014-01-27T16:36:29Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575650#M1119556 <HTML><HEAD></HEAD><BODY><P>Any help please</P></BODY></HTML> Mon, 27 Jan 2014 16:36:32 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575650#M1119556 2014-01-27T16:36:32Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575651#M1119557 <HTML><HEAD></HEAD><BODY><P>Try adding 'What' as another dimension and use a pivot table not a straight table to get the correct layout</P></BODY></HTML> Mon, 27 Jan 2014 16:42:09 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575651#M1119557 Anonymous 2014-01-27T16:42:09Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575652#M1119558 <HTML><HEAD></HEAD><BODY><P>Thanks and I tried using 'What'. But it is showing Balnk chart when am using'What'.</P><P></P><P>Please any help as I am unable to figure this out. and I would need the exact layout of same which is in png attached.</P></BODY></HTML> Mon, 27 Jan 2014 16:44:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575652#M1119558 2014-01-27T16:44:17Z Re: Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575653#M1119559 <HTML><HEAD></HEAD><BODY><P>is this what you are trying to achieve?</P></BODY></HTML> Mon, 27 Jan 2014 16:52:36 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575653#M1119559 Anonymous 2014-01-27T16:52:36Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575654#M1119560 <HTML><HEAD></HEAD><BODY><P>thanks and please can I know how you get the layout of Queue as Vertical?</P></BODY></HTML> Mon, 27 Jan 2014 16:57:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575654#M1119560 2014-01-27T16:57:45Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575655#M1119561 <HTML><HEAD></HEAD><BODY><P><BR />You can drag the columns to where you want them if you have the table as a pivot table</P></BODY></HTML> Mon, 27 Jan 2014 16:59:46 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575655#M1119561 Anonymous 2014-01-27T16:59:46Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575656#M1119562 <HTML><HEAD></HEAD><BODY><P>Hi, sorry I couldn't able to get can I have screen shot please.</P></BODY></HTML> Mon, 27 Jan 2014 17:05:08 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575656#M1119562 2014-01-27T17:05:08Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575657#M1119563 <HTML><HEAD></HEAD><BODY><P>Please any help as I am really struggling this </P></BODY></HTML> Mon, 27 Jan 2014 17:19:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575657#M1119563 2014-01-27T17:19:18Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575658#M1119564 <HTML><HEAD></HEAD><BODY><P><IMG alt="2014-01-27_1730.png" class="jive-image" height="244" src="https://community.qlik.com/legacyfs/online/52177_2014-01-27_1730.png" style="width: 644px; height: 244.09677419354838px;" width="644" /></P></BODY></HTML> Mon, 27 Jan 2014 17:32:34 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575658#M1119564 rustyfishbones 2014-01-27T17:32:34Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575659#M1119565 <HTML><HEAD></HEAD><BODY><P>when I am trying to drag nothing chamges for me please help please</P></BODY></HTML> Mon, 27 Jan 2014 17:32:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575659#M1119565 2014-01-27T17:32:48Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575660#M1119566 <HTML><HEAD></HEAD><BODY><P>Thanks and when I am doing this it is showing blue line at vertical place not horizontal.do I need to change anything?</P></BODY></HTML> Mon, 27 Jan 2014 17:34:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575660#M1119566 2014-01-27T17:34:30Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575661#M1119567 <HTML><HEAD></HEAD><BODY><P>Thanks and I can able to see Horizontal column but it is taking too long to appear. Could you let me know please how can I get individual percentages(%) which is showing in your screen shot.</P></BODY></HTML> Mon, 27 Jan 2014 17:42:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575661#M1119567 2014-01-27T17:42:17Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575662#M1119568 <HTML><HEAD></HEAD><BODY><P>Cant help till later, driving home</P></BODY></HTML> Mon, 27 Jan 2014 18:04:40 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575662#M1119568 rustyfishbones 2014-01-27T18:04:40Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575663#M1119569 <HTML><HEAD></HEAD><BODY><P>Amelia,</P><P></P><P>How about the attached solution? I have Queue on the Y-axis and What on the x-axis. Changed to count HistoryID instead of ClientID as a client can make several calls. You could easily change back to ClientID again though. You also have the %-calculation.</P><P></P><P><IMG alt="Totals.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52196_Totals.png" style="width: 620px; height: 454px;" /></P><P></P><P>Hope this helps.</P><P></P><P>Best regards,</P><P>Christian</P></BODY></HTML> Mon, 27 Jan 2014 22:24:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575663#M1119569 Christian_Lauritzen 2014-01-27T22:24:39Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575664#M1119570 <HTML><HEAD></HEAD><BODY><P>Hi Christian,</P><P></P><P>Thanks very much. I am getting values different when HistoryID is used as the vales are showing very ;arge compared when I use ClientID.Could I know how to calculate the exact values which are coming from access databaes? please help me. As it is showing different figures and exactly I would need to show how the<STRONG> Total</STRONG> breakdown into individual Queues along horizotal and vertical.</P></BODY></HTML> Tue, 28 Jan 2014 08:52:52 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575664#M1119570 2014-01-28T08:52:52Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575665#M1119571 <HTML><HEAD></HEAD><BODY><P>In the presentation tab you click the 'Partial Sum' checkbox on whichever expression you want to total.&nbsp; You can also have it at the top/bottom or left/right by changing the Subtotals from top to bottom also on the presentation tab</P></BODY></HTML> Tue, 28 Jan 2014 08:56:35 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575665#M1119571 Anonymous 2014-01-28T08:56:35Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575666#M1119572 <HTML><HEAD></HEAD><BODY><P>By selecting "Show Partial Sums" on "Chart Properties [Outcome] / Presentation"</P><P>But Attention in the Field "Dimensions and Expressions" "What" has to be selected first!</P></BODY></HTML> Tue, 28 Jan 2014 08:57:36 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575666#M1119572 heimo_ernst_wei 2014-01-28T08:57:36Z Re: How to get Breakdowns of Total https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575667#M1119573 <HTML><HEAD></HEAD><BODY><P>Thanks. Actually I am getting values very large figures. how can I set this?</P></BODY></HTML> Tue, 28 Jan 2014 08:57:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-Breakdowns-of-Total/m-p/575667#M1119573 2014-01-28T08:57:45Z