topic Re: Combo Chart bar Length in QlikView

Combo Chart bar Length

israrkhan — Thu, 28 May 2015 09:50:14 GMT

Hi Guys,

i have a simple Combo Chart, where i want to show total sale as bars, and brand sale as line...

this chart has one expression sum(Sale)...which is showing correct...

but now i have to add 2, 3 more expression to show the trend of a specific brand out of total...

i added second expression which is sum({< Brand = {'SAMSUNG'}>} Sale).

but now chart reduces the Bar length to very small...

see the image please...

problem is: i want to show the bar length as in above image, after adding second expression bar length become very small..

how to tell qlikview to not to reduce the length of bars...?

Many Thanks...

Khan

Re: Combo Chart bar Length

rubenmarin — Thu, 28 May 2015 09:55:49 GMT

Hi Khan, in chart properties-->axis tab you can set 'Samsung' expressing to the axis on th right.

Anyway before that I would check if values are correct, It's possible that only the brand Samsung in 2015-5 has a value of nearly 80 Millions while the Total Sale on that month was neraly 80 k?

Is Total Sale divided by 1000 and Samsung is not?

Re: Combo Chart bar Length

pokassov — Thu, 28 May 2015 09:56:33 GMT

Hello!

Could you change for second expression position (Right (Top) on Axes page in diagram's properties?

Re: Combo Chart bar Length

israrkhan — Thu, 28 May 2015 10:09:42 GMT

Many Thanks Guys...

both option works, and i was missing " Is Total Sale divided by 1000 and Samsung is not?"

its a test data...

Thanks Agian

Re: Combo Chart bar Length

buzzy996 — Thu, 28 May 2015 10:11:07 GMT

u can create & use 2nd y-axis for ur 2,3rd expressions,that makes the difference.