topic Re: Pivot Total Missing ?? in QlikView https://community.qlik.com/t5/QlikView/Pivot-Total-Missing/m-p/829657#M653695 <HTML><HEAD></HEAD><BODY><P>Try like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum( if((PK_Date&gt;=LastRefresh-7) or </SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FiscalWeek='2', </SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FTE))</SPAN></P></BODY></HTML> Wed, 08 Jul 2015 09:33:30 GMT swuehl 2015-07-08T09:33:30Z Pivot Total Missing ?? https://community.qlik.com/t5/QlikView/Pivot-Total-Missing/m-p/829656#M653694 <HTML><HEAD></HEAD><BODY><P>I have created a pivot table, but for some reason one of my columns does not show the total.&nbsp; The script behind this is as follows:</P><P></P><P>if((PK_Date&gt;=LastRefresh-7) or <SPAN style="font-size: 10pt; line-height: 1.5em;">FiscalWeek='2', </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">sum(FTE))</SPAN></P><P></P><P>Any ideas??</P><P></P><P><IMG alt="Qlik_Pivot.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92240_Qlik_Pivot.png" style="height: auto;" /></P></BODY></HTML> Wed, 08 Jul 2015 09:32:24 GMT https://community.qlik.com/t5/QlikView/Pivot-Total-Missing/m-p/829656#M653694 Anonymous 2015-07-08T09:32:24Z Re: Pivot Total Missing ?? https://community.qlik.com/t5/QlikView/Pivot-Total-Missing/m-p/829657#M653695 <HTML><HEAD></HEAD><BODY><P>Try like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum( if((PK_Date&gt;=LastRefresh-7) or </SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FiscalWeek='2', </SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FTE))</SPAN></P></BODY></HTML> Wed, 08 Jul 2015 09:33:30 GMT https://community.qlik.com/t5/QlikView/Pivot-Total-Missing/m-p/829657#M653695 swuehl 2015-07-08T09:33:30Z Re: Pivot Total Missing ?? https://community.qlik.com/t5/QlikView/Pivot-Total-Missing/m-p/829658#M653696 <HTML><HEAD></HEAD><BODY><P>The condition is unfulfilled for the total, the question is:</P><P></P><P>what are the values for</P><P></P><P>PK_Date, LastRefresh, <SPAN style="font-size: 10pt;">FiscalWeek</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">when you summarize all?</SPAN></P></BODY></HTML> Wed, 08 Jul 2015 09:36:57 GMT https://community.qlik.com/t5/QlikView/Pivot-Total-Missing/m-p/829658#M653696 alexandros17 2015-07-08T09:36:57Z