Combo Chart bar Length

[israrkhan]

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

[rubenmarin · Accepted solution]

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?

[pokassov]

Hello!

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

[israrkhan]

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

[buzzy996]

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