Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
hi,
SUM(Perc) * SUM(total {1<source = {'VAT_Costs'}, AsOf = {"=$(=GetFieldSelections(AsOf))"},PC, Activity >} myVal)
or
please provide some sample data.
$@M.