Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
dhernandez95
New Contributor

Re: Market share

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

MVP
MVP

Re: Market share

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.

The Magic of Dollar Expansions

Re: Market share

Hi Diego, if the question is already solved, please check the appropiate helpful/correct answers.

dhernandez95
New Contributor

Re: Market share

Thaks!

Your answer help me a lot!

dhernandez95
New Contributor

Re: Market share

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?

MVP
MVP

Re: Market share

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)

)