topic Re: QS. Combo chart. Secondary axis for bar in App Development

QS. Combo chart. Secondary axis for bar

RayArina — Sat, 16 Nov 2024 00:49:23 GMT

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
]
;

Re: QS. Combo chart. Secondary axis for bar

RayArina — Thu, 14 Jan 2021 22:35:34 GMT

Re: QS. Combo chart. Secondary axis for bar

Ksrinivasan — Fri, 15 Jan 2021 02:32:02 GMT

hi,

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

then sales trend become big,

ksrinivasan

Re: QS. Combo chart. Secondary axis for bar

RayArina — Fri, 15 Jan 2021 07:56:50 GMT

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)

Re: QS. Combo chart. Secondary axis for bar

Ksrinivasan — Fri, 15 Jan 2021 08:09:06 GMT

hi,

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

ksrinivasan

Re: QS. Combo chart. Secondary axis for bar

RayArina — Fri, 15 Jan 2021 08:15:52 GMT

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

Re: QS. Combo chart. Secondary axis for bar

Ksrinivasan — Fri, 15 Jan 2021 08:30:35 GMT

hi,

i am sry,

please refer below:

ksrinivasan

Re: QS. Combo chart. Secondary axis for bar

Ksrinivasan — Fri, 15 Jan 2021 08:34:28 GMT

hi, refer

https://www.youtube.com/watch?v=RkVDi0b2hmk

Ksrinivasan

Re: QS. Combo chart. Secondary axis for bar

RayArina — Fri, 15 Jan 2021 10:25:25 GMT

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