Problem in Hierarchy calculation

nirav_bhimani — Fri, 14 Dec 2012 07:03:22 GMT

HI Everyone,

I am creating one demo for recipe cost using hierarchy. While calculating the cost of root product it gave me wrong result i.e. 287.67 but according to manual calculation in excel it is 266.14 for Product A. see the sheet2. It happens because it is considering the sum of all the B components(Quantity * Unitcost) to that total ie. 266.14 + 20.52

Is there any way I can get the total as 266.14 as my final result.

Hierarchy Structure:

/ \

B C

B1.......... B11

Thanks & Regards,

Nirav Bhimani

Re: Problem in Hierarchy calculation

Gysbert_Wassenaar — Fri, 14 Dec 2012 10:49:08 GMT

You're summing costs of the B* parts twice since you've already included them in the unit cost of B. What you can do to present it as you want is use this expression:

if(Dimensionality()=3,SUM([Unit Cost]* Quantity),SUM({<Depth-={3}>}[Unit Cost]* Quantity))

Re: Problem in Hierarchy calculation

nirav_bhimani — Sat, 15 Dec 2012 05:54:27 GMT

Hi,

Thanks allot my friend. It works.

Thanks & Regards,

Nirav Bhimani

topic Problem in Hierarchy calculation in QlikView

Problem in Hierarchy calculation

Re: Problem in Hierarchy calculation

Re: Problem in Hierarchy calculation