topic allocating sum according to calculated share in QlikView

allocating sum according to calculated share

dafnis14 — Sat, 16 Nov 2024 19:04:39 GMT

Hi,

I need to allocate products revenue to a certain product (service).

My data:

Only products that are marked with the flag "In Report?" should be taken into account.

The service product is marked with the flag "Service?".

I fail to achieve it with Set Analysis. Maybe it's not feasible?

I used the expression:

sum({<Service?={1}>}Revenue)
*
(
sum({<[In Report?]={1}>} Revenue)
/
sum( TOTAL{<[In Report?]={1}>} Revenue)
)

Attached is a sample model I built.

Thanks in advance!

jochem_zw — Thu, 20 Feb 2020 21:43:08 GMT

please try

sum(total {<[Product Name]=,Service?={1}>}Revenue)
*
(
sum({<[In Report?]={1}>} Revenue)
/
sum( TOTAL{<[In Report?]={1}>} Revenue)
)

dafnis14 — Fri, 21 Feb 2020 05:04:15 GMT

Brilliant!

Thanks!