4 Replies Latest reply: Sep 27, 2017 7:39 AM by Anil Samineni

# Calculate Market Share in Qlik sense Chart

Dear All

How to calculate Market share in Qlik sense ?

Vikas

• ###### 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]),'##.#'& '%')

• ###### 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,

Vikas

• ###### Re: Calculate Market Share in Qlik sense Chart

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