Error Data display on Pivot Table

[Anonymous]

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.

[sunny_talwar · Accepted solution]

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)

[mightyqlikers]

hi,

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

or

please provide some sample data.

$@M.