Re: Calculate Market Share in Qlik sense Chart - Qlik Community

vikasmahajan · ‎2017-09-27

Dear All

How to calculate Market share in Qlik sense ?

Thanks in adv

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

shraddha_g · ‎2017-09-27

try,

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

else

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

Anil_Babu_Samineni · ‎2017-09-27

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vikasmahajan · ‎2017-09-27

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anil_Babu_Samineni · ‎2017-09-27

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful