topic Re: How to create this Chart? in QlikView

How to create this Chart?

hugmarcel — Sat, 16 Nov 2024 01:27:52 GMT

I'd like to create the chart in the image file attached. How is it possible?

1.) No overlaying allowed, shall be done in 1 single chart object only.

2.) I tried with stacked bar charts and gauge bar chart.

3.) I have experimented with free text elements ("Aktuelle Aktienquote") and position lines. My main problem is how to create the position lines exactly as displayed in the image.

Thank you and kind regards!

Marcel

Re: How to create this Chart?

Taoufiq_Zarra — Tue, 21 Jan 2020 14:32:17 GMT

are the values on the line known in advance? can we propose several lines with the option show hide ? no ?

Re: How to create this Chart?

hugmarcel — Tue, 21 Jan 2020 19:43:08 GMT

Hi Taoufiq

thank you for your answer.

All values are know in advance.

How will you position your lines, as line chart positions (horizontal, vertical) cannot be dynamically set.

Well, I said that only 1 single chart should be used, and line charts are additional charts...

Best - Marcel

Re: How to create this Chart?

Taoufiq_Zarra — Tue, 21 Jan 2020 21:26:24 GMT

Personally I've been thinking of adding several lines and displaying them according to the value of a variable.

Re: How to create this Chart?

hugmarcel — Wed, 22 Jan 2020 09:03:33 GMT

How do you position the lines "according to a variable"? I do not manage to set the horizontal position with a variable, only static values are allowed in the relevant line object field.

However, the requirement to use 1 single object only is not fulfilled by using line objects.

Best - Marcel

Re: How to create this Chart?

Taoufiq_Zarra — Wed, 22 Jan 2020 10:50:47 GMT

Hi Marcel,

I'm just thinking out loud,
I was thinking of adding several lines for example
since the bar from 0 to 100 is fixed.

one I'll put it on 10, another on 20 ....

and then add variables show hide according to the values

for example in the example in PJ, if you select values in the field Prod, lines are displayed.

it's just a reflection, I don't know if it can help.

Re: How to create this Chart?

jonathandienst — Wed, 22 Jan 2020 12:14:54 GMT

If you check the continuous option for the dimension axis (Chart Properties | Axes), then you can add vertical reference lines (Chart Properties | Presentation | Reference Lines). Select the Continuous X option. You can add and display a label as well.

And that's all in one object - but it does require the x-axis to be a continuous numeric value.

Re: How to create this Chart?

Taoufiq_Zarra — Wed, 22 Jan 2020 12:27:26 GMT

Thanks @jonathandienst
I completely forgot Reference Lines

Re: How to create this Chart?

hugmarcel — Wed, 22 Jan 2020 16:09:31 GMT

thank you, I know about the reference lines (I call them "position lines"). Unfortunately, it is not possible to display them exactly as in my image attached (part within the bar chart, and part either above or below the chart).

Thank you!

Marcel