How to Fixe Pivot Table result with any Selections on Fields

[Anonymous]

Hello,

I am a beginner on QlikView and i would like to show and freeze all values, but the result change when i select a field on the dimension:

When i select different elements on the field PC:

The values change and become bad:

The expression here is:

=SUM(TOTAL <PC> Val*Weight)/SUM(Total Val*Weight)

Do you have an idea of the problem please ?

Thanks in advance for your responses,

Sébastien.

[Chanty4u]

did u try with ALL

=SUM(All<PC> Val*Weight)/SUM(All Val*Weight)

[Kushal_Chawda]

try this

=SUM(Val*Weight)/SUM(Total <PC>Val*Weight)

[sunny_talwar · Accepted solution]

May be this:

=SUM(Val*Weight)/SUM(Total {<PC>}Val*Weight)

[tamilarasu]

If you don't want the selections to affect the pivot table, you can try below expression.

=SUM( {1} Val*Weight)/SUM( {1} Total <PC>Val*Weight)

[Anonymous]

I tried but Qlikview shows me an error 😕:

[santhosh_k_n]

Hi Sebaastien,

You try either of the two options,

1. Try to use alternate state or detach the object from the report inorder not to apply the filters

2. Use set analysis in the expression

BR

SK

[Anonymous]

It works perfectly, thanks a lot :

But when i choose another table (here DESK) which is connected to PC, the problem appears again :/:

The expression is:

=SUM(Val*Weight)/SUM(Total {<PC>}Val*Weight)

Thanks in advance for your help,

Sébastien.

[sunny_talwar]

May be ignore Desk also

=SUM(Val*Weight)/SUM(Total {<PC, Desks>}Val*Weight)

or ignore all selections in the denominator?

=SUM(Val*Weight)/SUM(Total {1}Val*Weight)

[Anonymous]

Perfect ! The first solution works great .

But not the second 😕