topic How to Fixe Pivot Table result with any Selections on Fields in QlikView

How to Fixe Pivot Table result with any Selections on Fields

Anonymous — Tue, 19 Apr 2016 11:59:28 GMT

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.

Re: How to Fixe Pivot Table result with any Selections on Fields

Chanty4u — Tue, 19 Apr 2016 12:01:53 GMT

did u try with ALL

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

Re: How to Fixe Pivot Table result with any Selections on Fields

Kushal_Chawda — Tue, 19 Apr 2016 12:11:58 GMT

try this

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

Re: How to Fixe Pivot Table result with any Selections on Fields

sunny_talwar — Tue, 19 Apr 2016 12:31:46 GMT

May be this:

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

Re: How to Fixe Pivot Table result with any Selections on Fields

tamilarasu — Tue, 19 Apr 2016 12:45:26 GMT

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)

Re: How to Fixe Pivot Table result with any Selections on Fields

Anonymous — Tue, 19 Apr 2016 12:50:52 GMT

I tried but Qlikview shows me an error 😕:

Re: How to Fixe Pivot Table result with any Selections on Fields

santhosh_k_n — Tue, 19 Apr 2016 12:52:43 GMT

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

Re: How to Fixe Pivot Table result with any Selections on Fields

Anonymous — Tue, 19 Apr 2016 12:58:40 GMT

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.

Re: How to Fixe Pivot Table result with any Selections on Fields

sunny_talwar — Tue, 19 Apr 2016 13:01:04 GMT

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)

Re: How to Fixe Pivot Table result with any Selections on Fields

Anonymous — Tue, 19 Apr 2016 13:03:21 GMT

Perfect ! The first solution works great .

But not the second 😕