Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day to everyone.
I am in a BI project, in this project I have to show the participation of a business in front of its competition, both belonging to the same line.
Example
"In an urban area there are 5 record stores:
SHOP A,
SHOP B,
SHOP C,
SHOP D
SHOP E,
all these stores represent 100%, but I need to know the percentage of the SHOP A compared to the other stores (these have to be grouped as "Market") so that this way you can read something like this: SHOP A has a participation of 19% against its market which is 81%.
I would greatly appreciate your help.
Thanks
Thank you very very much!
You have helped me a lot, you just would mind explaining the next part of the expression:
$ (= Concat (DISTINCT chr (39) & FAM_N_GIRO & chr (39), ','))
Please
That's a dollar sign expansion.
It will just input a list of possible FAM_N_GIRO values, comma separated and quoted in the calculated dimension, before the expression gets parsed and evaluated, like a preprocessor text replacement.
Hi Diego, if the question is already solved, please check the appropiate helpful/correct answers.
Thaks!
Your answer help me a lot!
Good day!
The answer you gave me was correct.
I made a bar graph and on measure put the following function:
= Sum ({<FAM_N_GIRO =>} AMOUNT)
And I see two bars: one for "Market" and the other for the family that I select, but in the "amount" for "market" I omit the amount of the selected family.
My question is: How can I do so that in "Market" I see the total of all families and apart from the family selected?
Not quite sure that I understand your last sentence.You want to see in Market the total value including the amount of the selected family?
With QlikView, it would be just a bar chart without a dimension and two expressions,
=Sum(AMOUNT)
=Sum ({<FAM_N_GIRO =>} AMOUNT)
two compare the selected AMOUNT against the total.
QlikSense does not allow a bar chart without a dimension, but you can create a synthetic, calculated dimension using ValueList():
=Valuelist('$(=Only(FAM_N_GIRO))','Market')
and a single expression:
=If(Valuelist('$(=Only(FAM_N_GIRO))','Market')='$(=Only(FAM_N_GIRO))',
Sum(AMOUNT),
Sum({<FAM_N_GIRO>} AMOUNT)
)