Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
My bad, I wanted to ask about BEAUTE ET LUXE field and not BAGAGERIE... Is BEAUTE ET LUXE part of [Nomenclature 1] field?
The result is 100% as if to consider only "Nomenclature 2"
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...
it's right
I am working on Qlik network version on the company's computer network
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]))))
Great
Thank you for giving me time for my problem
Not a problem