How to multiply an amount by a value in a table

paul_ripley — Sat, 16 Nov 2024 02:00:25 GMT

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

Re: How to multiply an amount by a value in a table

Arthur_Fong — Fri, 08 Nov 2019 00:11:24 GMT

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.

topic Re: How to multiply an amount by a value in a table in QlikView

How to multiply an amount by a value in a table

Re: How to multiply an amount by a value in a table