Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
israrkhan
Specialist II
Specialist II

Combo Chart bar Length

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...

1.png

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...

2.png

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

1 Solution

Accepted Solutions
rubenmarin

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?

View solution in original post

4 Replies
rubenmarin

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
Specialist
Specialist

Hello!

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

israrkhan
Specialist II
Specialist II
Author

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
Master II
Master II

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