topic Error Data display on Pivot Table in QlikView

Error Data display on Pivot Table

Anonymous — Tue, 26 Apr 2016 09:08:37 GMT

Hello All,

I am a beginner on QlikView and i want to multiply a total of VAT ( here equal to -28) by the percentage of each individuals (here Activity dimension).

Here my Pivot Table:

The expression of the Column 1 (Percentage):

=SUM(Perc)

The expression of the Column 2 (VAT):

=SUM({1<source = {'VAT_Costs'}, AsOf = {"=$(=GetFieldSelections(AsOf))"},PC, Activity >} myVal)

The expression of the Column 3 (Result):

= SUM(Perc) * SUM({1<source = {'VAT_Costs'}, AsOf = {"=$(=GetFieldSelections(AsOf))"},PC, Activity >} myVal)

Have you got an idea or an advice please ?

Thanks in advance for your responses,

Sébastien.

Re: Error Data display on Pivot Table

sunny_talwar — Tue, 26 Apr 2016 09:10:28 GMT

May be try this:

= SUM(Perc) * SUM(TOTAL {1<source = {'VAT_Costs'}, AsOf = {"=$(=GetFieldSelections(AsOf))"},PC, Activity >} myVal)

and

=SUM(TOTAL {1<source = {'VAT_Costs'}, AsOf = {"=$(=GetFieldSelections(AsOf))"},PC, Activity >} myVal)

Re: Error Data display on Pivot Table

mightyqlikers — Tue, 26 Apr 2016 09:12:23 GMT

hi,

SUM(Perc) * SUM(total {1<source = {'VAT_Costs'}, AsOf = {"=$(=GetFieldSelections(AsOf))"},PC, Activity >} myVal)

please provide some sample data.

$@M.