Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
RayArina
Contributor III
Contributor III

QS. Combo chart. Secondary axis for bar

Hello everybody!
I want to show the sales increase like a bar and on the secondary axis
Can I do this? Is it possible?

Now I have the next situation
if the increase is a line - everything is ok
if the increase is a marker - it is displayed on the secondary axis but without value labels/markers
if the increase is a bar - it is not displayed at all because it is too small to be displayed on the primary axis but the secondary axis cannot be selected

 

load * inline
[
year ,month ,sales
1 ,1 ,4334
1 ,2 ,3303
1 ,3 ,1956
1 ,4 ,4123
1 ,5 ,2015
2 ,1 ,5245
2 ,2 ,4393
2 ,3 ,2485
2 ,4 ,5154
2 ,5 ,2761
]
;

Labels (1)
2 Solutions

Accepted Solutions
RayArina
Contributor III
Contributor III
Author

Thank
I just made the sale on the secondary axis and the increase on the primary
and it is works

it may not be possible to make bars on the secondary axis

ok.jpg

 

View solution in original post

8 Replies
RayArina
Contributor III
Contributor III
Author

example.jpg

Ksrinivasan
Specialist
Specialist

hi,

you have to set Minmum 0 and Maximum 100% in sales trend chart in appearance setting ,

then sales trend become big,

ksrinivasan

RayArina
Contributor III
Contributor III
Author

Thank you for your advice))
But I need 2 line (sales) in thousands and 1 bar (increase) in %
QS has no "Split axis", so a secondary axis is needed here

For example this is what I want (QV)

need.jpg

RayArina
Contributor III
Contributor III
Author

https://community.qlik.com/t5/New-to-QlikView/set-secondary-axis-in-a-chart/m-p/1026810

It is QV

In QV I show the example

Need the same thing in QS ^-^

 

Ksrinivasan
Specialist
Specialist

hi,

i am sry,

please refer below:

Ksrinivasan_0-1610699384093.png

ksrinivasan

RayArina
Contributor III
Contributor III
Author

Thank
I just made the sale on the secondary axis and the increase on the primary
and it is works

it may not be possible to make bars on the secondary axis

ok.jpg