topic Re: % 3 dimensions in App Development

% 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 09:14:12 GMT

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

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 09:30:25 GMT

Would you be able to share a sample to show the issue?

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 09:38:41 GMT

Below screenshot of my erroneous result.
"BEAUTE ET LUXE" => result OK
"BAGAGERIE" => result NOT OK
"ACCESSOIRES BAGAGERIE" => result OK

thank you in advance

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 11:52:48 GMT

Can you create a new expression

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

What value do you get here?

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 12:00:43 GMT

I get the total of "CA HT 2017": 202733 euros

It's weird ...

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 12:03:04 GMT

So right now you are getting 973/202733, whereas you want 973/10528? Is that right?

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 12:04:21 GMT

That's right

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 12:06:16 GMT

Is BAGAGERIE part of [Nomenclature 1]?

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 12:07:43 GMT

No, it is part of "Nomenclature 2"

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 12:11:09 GMT

Can you try this for dimensionality() = 2

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

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 12:12:54 GMT

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

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 12:13:42 GMT

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

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 12:15:00 GMT

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...

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 12:15:04 GMT

it's right

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 12:18:25 GMT

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

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 12:42:40 GMT

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]))))

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 13:55:33 GMT

Great

Re: % 3 dimensions

benjamin_rhinos — Wed, 10 May 2017 14:51:55 GMT

Thank you for giving me time for my problem

Re: % 3 dimensions

sunny_talwar — Wed, 10 May 2017 14:58:44 GMT

Not a problem