topic Showing only one value on Pivot table Partial Sums -- Problem with one expression in QlikView https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551400#M555143 <HTML><HEAD></HEAD><BODY><P>Hello folks, I created the Pivot Table and I used Partial sums option on the my dimension (Quarter).</P><P>I have 3 expressions: 1.Actual 2. Budget or Forcast (Based on selections) 3. Variance</P><P>I created the YTD by selecting Partial Sum value on the Quarter dimension and I selected indent mode.</P><P>If user selected 'Budget' in the selections , the YTD for Actaul, Budget and variance showing correctly.</P><P>But if user selected 'Forecast' in the selections, the YTD for Forcast showing only Q2.</P><P>Please find the attached document.</P><P></P><P>Can anyone face this problem before ?</P><P></P><P>Any insights to solve the problem</P><P></P><P>sample qvw attached</P></BODY></HTML> Fri, 02 Aug 2013 02:18:13 GMT 2013-08-02T02:18:13Z Showing only one value on Pivot table Partial Sums -- Problem with one expression https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551400#M555143 <HTML><HEAD></HEAD><BODY><P>Hello folks, I created the Pivot Table and I used Partial sums option on the my dimension (Quarter).</P><P>I have 3 expressions: 1.Actual 2. Budget or Forcast (Based on selections) 3. Variance</P><P>I created the YTD by selecting Partial Sum value on the Quarter dimension and I selected indent mode.</P><P>If user selected 'Budget' in the selections , the YTD for Actaul, Budget and variance showing correctly.</P><P>But if user selected 'Forecast' in the selections, the YTD for Forcast showing only Q2.</P><P>Please find the attached document.</P><P></P><P>Can anyone face this problem before ?</P><P></P><P>Any insights to solve the problem</P><P></P><P>sample qvw attached</P></BODY></HTML> Fri, 02 Aug 2013 02:18:13 GMT https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551400#M555143 2013-08-02T02:18:13Z Re: Showing only one value on Pivot table Partial Sums -- Problem with one expression https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551401#M555144 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Is it possible to upload your application?</P></BODY></HTML> Fri, 02 Aug 2013 04:52:18 GMT https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551401#M555144 2013-08-02T04:52:18Z Re: Showing only one value on Pivot table Partial Sums -- Problem with one expression https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551402#M555145 <HTML><HEAD></HEAD><BODY><P>sample qvw was attached</P></BODY></HTML> Fri, 02 Aug 2013 12:28:33 GMT https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551402#M555145 2013-08-02T12:28:33Z Re: Showing only one value on Pivot table Partial Sums -- Problem with one expression https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551403#M555146 <HTML><HEAD></HEAD><BODY><P>The Partila Sum option, just sum the values of the expression results or calculate the expression overall on the dimension ??</P></BODY></HTML> Fri, 02 Aug 2013 18:13:39 GMT https://community.qlik.com/t5/QlikView/Showing-only-one-value-on-Pivot-table-Partial-Sums-Problem-with/m-p/551403#M555146 2013-08-02T18:13:39Z