Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

timpoismans
Valued Contributor

Dividing costs

Hi all

I have the following problem:

We got a customer which has a Head Office and several other offices.

I need to divide costs booked on the Head Office (Marked in yellow in first picture) between the other offices.

Example of the data:

TeVerdelenOmzet.PNG

The data marked in yellow are the costs that I need to divide between the other offices.

But as my table has the offices as column dimension, I can't seem to get the value of the "Head Office" calculated under any of the other offices.

What it would need to look like is the following:

TeVerdelenOmzet_Ideal.PNG

Formula for the values is a simple "Sum(Bedrag)".

Any help is appreciated and thanks in advance!

Kind regards,

Tim P.

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: Dividing costs

For the Head office Bedrag in other offices column you can probably use  the TOTAL keyword, something like

Sum({<Office={'Head Office'}>}TOTAL bedrag)

Depending on other dimensions you may need to specify which Dimension to take the total from

TOTAL <Dimension>

2 Replies
stigchel
Honored Contributor

Re: Dividing costs

For the Head office Bedrag in other offices column you can probably use  the TOTAL keyword, something like

Sum({<Office={'Head Office'}>}TOTAL bedrag)

Depending on other dimensions you may need to specify which Dimension to take the total from

TOTAL <Dimension>

timpoismans
Valued Contributor

Re: Dividing costs

Works llike a charm.

Thanks Piet!

Community Browser