% 3 dimensions

[benjamin_rhinos]

Hello, I want to calculate the% of my turnover by product family on the total turnover.

I have 3 dimensions : nomenclature 1 / nomenclature 2 / nomenclature 3

- the% of the nomenclature number 1 s / total digit => OK

- the% of the nomenclature number 2 s / total nomenclature 1 => NOT OK

- the% of the nomenclature number 3 s / total nomenclature 2 => OK

I do not understand why 2nd is not working. 

Scripts used :

  If (dimensionality () = ('1'),

Sum ([PV HT]) / sum (TOTAL [PV HT]),

If (dimensionality () = ('2'),

Sum ([PV HT]) / sum (TOTAL <[Nomenclature 1]> [PV HT]),

If (dimensionality () = ('3'),

Sum ([PV HT]) / sum (TOTAL <[Nomenclature 2]> [PV HT])

)))) 

Thank you for your help

[sunny_talwar]

My bad, I wanted to ask about BEAUTE ET LUXE field and not BAGAGERIE... Is BEAUTE ET LUXE part of [Nomenclature 1] field?

[benjamin_rhinos]

The result is 100% as if to consider only "Nomenclature 2"

[sunny_talwar]

Would you be able to share your file to check it out? From what you are sharing it seems that it should work... I have not idea why it might not be working...

[benjamin_rhinos]

it's right

[benjamin_rhinos]

I am working on Qlik network version on the company's computer network

[benjamin_rhinos]

I found where my error came from.

I excluded data from "Nomenclature 1" in my lines of my crosstab,

here is the script:

If ([Nomenclature 1] = ('TEST'), (''),
If ([Nomenclature 1] = ('FRAIS'), (''),
If ([Nomenclature 1] = ('PLV'), ('')
If ([Nomenclature 1] = ('SERVICE'), ('')
[Nomenclature 1]))))

[sunny_talwar]

Great

[benjamin_rhinos]

Thank you for giving me time for my problem

[sunny_talwar]

Not a problem