topic Re: Marketshare in pivot for groups seperately calculating wrong in QlikView

Marketshare in pivot for groups seperately calculating wrong

louwriet — Wed, 17 Sep 2014 12:27:49 GMT

Hi ,

I have a senario at client where they want to see their marketshare for their products in these products groups. This would now be the marketshare against competitor products.

When i say groups it means my company manufacturer for instance. Group Garden Tools - my product here would be a spade.

second Group would be for instance Lawnmowers - my product would be here Flymo 230 for instance. So what i need is to calculate my products marketshare against competittor products in that group.

My problem comes in where i have the groups in one pivot and instead of calculating the marketshares for each group out of 100% it takes all products of both groups and calculate then the product marketshare out of 100%

At the end i would like to see my two products with their marketshares within their groups.

Attached is a demo model with what i get and with picture what i actually want to achieve.

Help would really be appreciated

Louw

Re: Marketshare in pivot for groups seperately calculating wrong

JonnyPoole — Wed, 17 Sep 2014 14:20:51 GMT

here is my solution:

1. Expression formula:

sum( VALUE)

sum( TOTAL <YEARMONTH,GROUP> VALUE)

a) Expression formula:

sum( {$<MANUFACTURER={'MANUFACT_MY'}>} VALUE)

sum( TOTAL <YEARMONTH,GROUP> VALUE)

b) Replace calculated Manufacturer dimension with a regular dimension for manufacturer

Re: Marketshare in pivot for groups seperately calculating wrong

louwriet — Wed, 17 Sep 2014 20:46:30 GMT

Hi Jonathan,

Your suggested solution worked perfectly for my senario.

Thank so much !

Louw