topic Re: aggr help in QlikView

aggr help

Thu, 30 Mar 2017 13:33:49 GMT

Hi all,

i have an issue (attached)

2 bases with 3 common dimension names and i need in a table, which i use another dimension, to put a sumprod (of each item) between 2 other dimensions - Value1 & Value2 named in the example attached.

can anyone help please?

Thanks in advance!

Cosmin

Re: aggr help

sunny_talwar — Thu, 30 Mar 2017 13:51:29 GMT

Are you trying to get this?

Used Sum(Value1*Value2) in a pivot table with Department and Year as dimension

Re: aggr help

Thu, 30 Mar 2017 14:22:04 GMT

i reattached the excel source and it have also the results which i need (please reload it, i edited the figures a little bit, there where identical)

thank you!

Re: aggr help

Anonymous — Thu, 30 Mar 2017 14:36:11 GMT

like this?? didn't reload the latest data, but got the output you need. you can reload.

Re: aggr help

Thu, 30 Mar 2017 15:14:59 GMT

please give the expression as text in message, i use the free version

thanks

Re: aggr help

Anonymous — Thu, 30 Mar 2017 15:19:21 GMT

create a pivot table with Department as row dimension nd year as column dimension.

Use expression = sum(value1*Value2).

Go to presentation and check partial sums for both Department and Year.

Will result in below.

Re: aggr help

Thu, 30 Mar 2017 15:32:18 GMT

please reload my last excel..there are the results too

it doesn't work sum(value1*value2)

for B-2017 has to be 100 in your table, but pls reload the last excel.

many thanks!

Re: aggr help

Thu, 30 Mar 2017 15:41:19 GMT

with this works when i select an item ..C for example but if there is no selection it doesn't work properly

=sum(aggr(sum({<Year={'2017'}>}Value1*Value2), ID))