Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Hi

Is it possible to upload your application?

Not applicable
Author

sample qvw was attached

Not applicable
Author

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