How to multiply an amount by a value in a table

[paul_ripley]

Hello

I have a table in excel which i have loaded into my app using

infra_allocs:
LOAD infra_area,
Core,
US,
PPP,
India,
Central,
Exco
FROM
[O:\QlikView\ConsolOpex.xlsx]
(ooxml, embedded labels, table is InfraAllocs);

At the moment my calculation is as below

=round(
Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {">0"},
team -= {300,200,850,860,220,830,820},
busarea = {IN},costc = {516},
Datasource = {'Actual'}
>} $(vCurrency)))*.6

I am mulitplying values for Core for example by 0.6 .  I have other expressions for US and PPP etc

For example the same as above with * infra_area = Core (i know thats wrong but just cant work it out!)

I wanted to use the table to replace the 0.6 by set analysis so that I can update the value in excel and it automatically updates on QV.  I just cant work out what the set analysis would be

Could you please assist

Thanks

Paul

[Arthur_Fong · Accepted solution]

Try:

=round(
Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {">0"},
team -= {300,200,850,860,220,830,820},
busarea = {IN},costc = {516},
Datasource = {'Actual'}
>} $(vCurrency)*Core))

Replace to US or PPP for other expressions.