Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Calculating participation (Market Share)

Hi there.

Would somone help me on how I can calculate the market share or participation of each dimension row for a table with one dimension and one sum(e.g.sold value) for the expression.

1 Reply
richard_pearce6
Valued Contributor

Re: Calculating participation (Market Share)

Hi,

Have you tried using the expression: sum( Sold_Value) / Sum (Total Sold_Value) ?

If you're just interested in the frequency of the Dimension I tend to add a new row in the table import script:

1 as RowCount

The expressions now becomes: sum( RowCount) / Sum (Total RowCount)

Richard

Community Browser