Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Showing only one value on Pivot table Partial Sums -- Problem with one expression

Hello folks, I created the Pivot Table and I used Partial sums option on the my dimension (Quarter).

I have 3 expressions: 1.Actual 2. Budget or Forcast (Based on selections) 3. Variance

I created the YTD by selecting Partial Sum value on the Quarter dimension and I selected indent mode.

If user selected 'Budget' in the selections , the YTD for Actaul, Budget and variance showing correctly.

But if user selected 'Forecast' in the selections, the YTD for Forcast showing only Q2.

Please find the attached document.

Can anyone face this problem before ?

Any insights to solve the problem

sample qvw attached

3 Replies
Not applicable

Re: Showing only one value on Pivot table Partial Sums -- Problem with one expression

Hi

Is it possible to upload your application?

Not applicable

Re: Showing only one value on Pivot table Partial Sums -- Problem with one expression

sample qvw was attached

Not applicable

Re: Showing only one value on Pivot table Partial Sums -- Problem with one expression

The Partila Sum option, just sum the values of the expression results or calculate the expression overall on the dimension ??