# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Honored Contributor III

## Calculate Market Share in Qlik sense Chart

Dear All

How to calculate Market share in Qlik sense ?

Vikas

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

MVP

## Re: Calculate Market Share in Qlik sense Chart

 Where Variable is  vBPCLVolKL =Sum( Total    {\$}  [VolKL]) Sum(TOTAL {\$} [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 !!!
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,