topic Re: Bar chart shared value in QlikView

Bar chart shared value

raju_salmon — Tue, 24 May 2016 06:30:52 GMT

Hi,

I have 3 employees sales data. I need to show a bar chat with

Sum({<EMP={1}>}Sales) - $2000

Sum({<EMP={2}>}Sales) - $3000

Sum({<EMP={3}>}Sales) - $5000

Assume above information is for one month. My dimension is month.

I have a requirement to show a bar chart where it should show Y axis from 0% to 100% (like 0%, 20%,40%,60%,80%,100%)

and Emp 1 share is 20%, Emp 2 share is 30% and Emp 3 share is 50% (based on above values).

Can we achieve this with bar chart? if yes, may i know how can we do this?

Thanks for your help.

Kushal_Chawda — Tue, 24 May 2016 06:36:12 GMT

Dimension :

Month

Expression:

=num(Sum({<EMP={1}>}Sales) / Sum(Total Sales),'#0.00%')

num(Sum({<EMP={2}>}Sales) / Sum(Total Sales) ,'#0.00%')

num(Sum({<EMP={3}>}Sales) / Sum(Total Sales),'#0.00%')

Go to Properties-> Style -> Check Stack

Tue, 24 May 2016 06:42:48 GMT

you can show this :

dimension is EMP

expression : Sum({<EMP={1}>}Sales) mark as relative

Sum({<EMP={2}>}Sales) mark as relative

Sum({<EMP={3}>}Sales) mark as relative

select % for the 3 expressions in the numbers tab

raju_salmon — Tue, 24 May 2016 06:47:05 GMT

Thanks guys...Got self solution...

Sum({<EMP={1}>}Sales)

(Sum({<EMP={1}>}Sales)+Sum({<EMP={2}>}Sales)+Sum({<EMP={3}>}Sales))

Same for next two expressions...

Kushal_Chawda — Tue, 24 May 2016 06:49:36 GMT

It's better to use Sum(Total Sales), instead summing up 3 expressions, which means evaluating 3 different expressions.

raju_salmon — Tue, 24 May 2016 07:04:47 GMT

Hi Kushal,

I need to see this share between only these employees. If new emp added it causes issue. So... hope u got my point.

Thanks for your time.

Kushal_Chawda — Tue, 24 May 2016 07:09:47 GMT

Ok then use single expression

Sum({<EMP={'1','2','3'}>}Sales)