Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Freeze the result of the partial sum

Hello,

I started on QlikView, and I do not see how I can fix the result of my partial amount (here named CTY) on my table pivot.

Capture.PNG

Capture1.PNG

Do you have a solution ?

Thank you in advance for your help,

Cocalero.

2 Replies
swuehl
MVP
MVP

You could use Dimensionality() / SecondaryDimensionality() to check in your expression if the evaluation takes place in your partial sum.

So you could branch your expression into an expression that gets calculated on detail and one that gets calculated on total cells.

And if you need to ignore some selections, you could use set analysis.

This may sound not really helpful, but with the information provided, I can't offer more specific help.

If possible, post a small sample QVW and describe what your expected result is.

Chanty4u
MVP
MVP

can u eloberate  ur issue with expected output?