# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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), ','))

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

MVP

Highlighted
New Contributor

Thaks!

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

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

)