topic Re: Custom Report- Market Share Formula in QlikView

Custom Report- Market Share Formula

Tue, 21 Jan 2014 18:24:28 GMT

Hi All,

I am trying to calculate Market Share for Competitors across various dimensions. Attached is a sample file with competitors and different market divisions. It is a custom report and fields can be selected like a pivot in excel. However i am not able to get the market share formula right. Please help.

Thanks.

Re: Custom Report- Market Share Formula

Anonymous — Tue, 21 Jan 2014 18:38:31 GMT

Maybe this is what you need (?):

Sum(Units)/(sum(Total<Competitors> Units))

Re: Custom Report- Market Share Formula

Tue, 21 Jan 2014 18:45:43 GMT

Thanks Michael. The formula is only working for Competitors field but not for all fields.

Re: Custom Report- Market Share Formula

Anonymous — Tue, 21 Jan 2014 18:54:03 GMT

I though this is what you wanted...

What about this:

Sum(Units)/(sum(Total Units))

Re: Custom Report- Market Share Formula

maxgro — Tue, 21 Jan 2014 19:12:29 GMT

=Sum(total <Category, Competitors> Units)/(sum(Total <Category >Units))

Re: Custom Report- Market Share Formula

Tue, 21 Jan 2014 19:25:20 GMT

Thanks Massimo,

This formula only works in case of Category and Competitors. Other Dimension does not show any result.

Re: Custom Report- Market Share Formula

Anonymous — Tue, 21 Jan 2014 19:29:11 GMT

I see what you need - a dynamic total<>. You cannot use expression within total<>.

Here is how you can do it. Create a variable Var, define it this way:

='total<' & GetFieldSelections(_dimension) & '>'

Use it in expression:

=Sum($(Var) Units)/(sum(Total <Category >Units))

Re: Custom Report- Market Share Formula

sebastiandperei — Tue, 21 Jan 2014 19:40:50 GMT

Gaurang: for calculate Market Share, you need to get one total Market (by all competitors) and a parcial Market (for one competitor)

For example, when you have Category and Competitors, what do you want to see?