Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikasmahajan
Honored Contributor III

Calculate Market Share in Qlik sense Chart

Dear All

How to calculate Market share in Qlik sense ?

Thanks in adv

Vikas

4 Replies
shraddha_g
Honored Contributor III

Re: Calculate Market Share in Qlik sense Chart

try,

num(Sum({$<Company ={'BPC'}>} [VolKL])/$(vBPCLVolKL),'##.#'& '%')

else

num(Sum({$<Company ={'BPC'}>} [VolKL])/$(=vBPCLVolKL),'##.#'& '%')

Re: Calculate Market Share in Qlik sense Chart

Where Variable is  vBPCLVolKL =Sum( Total  <CalendarDay>  {$<COMP ={'BPCL'}>}  [VolKL])


Sum(TOTAL {$<Company ={'BPC'}>} [VolKL]),'##.#'& '%')

But, You are storing variable as different. Try this?

vBPCLVolKL = Sum(TOTAL {$<Company ={'BPC'}>} [VolKL]),'##.#'& '%')

Life is so rich, and we need to respect to the life !!!
vikasmahajan
Honored Contributor III

Re: Calculate Market Share in Qlik sense Chart

Created Variable  LET vTotalSale='Sum(TOTAL {1<COMP ={"BPCL"}>} [VolKL])';

used this in charts so that if we need to select particular customer then this will not show you 100% market share but exact what he has,

Thanks Guys for your reply

Vikas

Re: Calculate Market Share in Qlik sense Chart

Great, You can close this thread by flag your response as option

Life is so rich, and we need to respect to the life !!!
Community Browser