topic Re: Total Line beside Details in QlikView https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27136#M4531 <HTML><HEAD></HEAD><BODY><P>Not this year. I was there last year, but planning to attend Master Summit later in the year.</P></BODY></HTML> Thu, 12 Apr 2018 13:47:09 GMT sunny_talwar 2018-04-12T13:47:09Z Total Line beside Details https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27132#M4527 <HTML><HEAD></HEAD><BODY><P>Good Morning All,</P><P>I need to create a pivot table with totals beside the details.&nbsp; Any ideas?&nbsp; It's putting the same values in all years for Term Emp Co..&nbsp; I'm using this:</P><P><SPAN style="color: #0000ff; font-size: 12pt;">count</SPAN><SPAN style="font-size: 12pt;">({&lt;<SPAN style="color: #800000;">Level2</SPAN>=,<SPAN style="color: #800000;">Reason</SPAN>=,<SPAN style="color: #800000;">Job</SPAN>=,<SPAN style="color: #800000;">Ethnic</SPAN>=,<SPAN style="color: #800000;">InActive</SPAN> = {1},<SPAN style="color: #800000;">YTDFlag</SPAN> = {1}&gt;}&nbsp; <SPAN style="color: #0000ff;">Total</SPAN> <SPAN style="color: #0000ff;">DISTINCT</SPAN>(<SPAN style="color: #800000;">[Employee Number]</SPAN></SPAN><SPAN style="font-size: 12pt;">))&nbsp; </SPAN></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199431_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 12 Apr 2018 13:37:16 GMT https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27132#M4527 tmumaw 2018-04-12T13:37:16Z Re: Total Line beside Details https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27133#M4528 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count({&lt;Level2, Reason, Job, Ethnic, InActive = {1}, YTDFlag = {1}&gt;}&nbsp; TOTAL <SPAN style="color: #ff0000;">&lt;YearField&gt;</SPAN> DISTINCT [Employee Number])</STRONG></P></BODY></HTML> Thu, 12 Apr 2018 13:39:57 GMT https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27133#M4528 sunny_talwar 2018-04-12T13:39:57Z Re: Total Line beside Details https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27134#M4529 <HTML><HEAD></HEAD><BODY><P>Perhaps <STRONG>(TOTAL &lt;FieldName&gt; ....)</STRONG></P></BODY></HTML> Thu, 12 Apr 2018 13:40:59 GMT https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27134#M4529 Anil_Babu_Samineni 2018-04-12T13:40:59Z Re: Total Line beside Details https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27135#M4530 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny....are you going to Qonnections?</P></BODY></HTML> Thu, 12 Apr 2018 13:46:29 GMT https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27135#M4530 tmumaw 2018-04-12T13:46:29Z Re: Total Line beside Details https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27136#M4531 <HTML><HEAD></HEAD><BODY><P>Not this year. I was there last year, but planning to attend Master Summit later in the year.</P></BODY></HTML> Thu, 12 Apr 2018 13:47:09 GMT https://community.qlik.com/t5/QlikView/Total-Line-beside-Details/m-p/27136#M4531 sunny_talwar 2018-04-12T13:47:09Z