Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.