topic Re: Combo Chart in QlikView

Combo Chart

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

LOAD * INLINE [

Company, Area, Yes, NO, ID2

Test, AAA, 20, 15, 0

Test, AAA, 23, 16, 1

Test, AAA, 28, 17, 2

Test, AAA, 33, 18, 3

Test, AAA, 38, 19, 4

Test, AAA, 43, 20, 5

Test, AAA, 48, 21, 6

Test, BBB, 53, 20, 7

Test, BBB, 58, 18, 8

Test, BBB, 63, 16, 9

Test, BBB, 68, 14, 10

Test, BBB, 73, 12, 11

Test, BBB, 78, 10, 12

Test, BBB, 83, 8, 13

Test, CCC, 88, 6, 14

Test, CCC, 93, 4, 15

Test, CCC, 98, 2, 16

Test, CCC, 103, 0, 17

Test, CCC, 108, 0, 18

Test, CCC, 113, 0, 19

Test, CCC, 118, 0, 20

];

By using above data is it possible to show chart like below

I m not able get it , coming like below and also idont have idea how to create those reference liness

Did any one created this kind of chart.

Re: Combo Chart

Anil_Babu_Samineni — Thu, 20 Oct 2016 10:50:28 GMT

Can you please provide the Expression, Which you taken over there?

Re: Combo Chart

subbareddykm — Thu, 20 Oct 2016 11:01:35 GMT

Normal sum only, with stacked one

Re: Combo Chart

sunny_talwar — Thu, 20 Oct 2016 11:08:57 GMT

This is the closed I managed to get with 5-10 minutes of play around with this. I am sure you can further fine tune this, but see if this is close to what you want

Re: Combo Chart

sunny_talwar — Thu, 20 Oct 2016 11:11:40 GMT

Added another way to do this without using valuelist

Re: Combo Chart

Anil_Babu_Samineni — Thu, 20 Oct 2016 11:14:01 GMT

The Reason is It's not possible with Two dimensions as you expected. Work around Try with Sunny T Solution. I am sure, I've read same kind of thread. I didn't remember his name. I think Manish Kachhia posted the similar. Hope he will explain you. Anyway, Once i reach i might can share that Application with you

Updated: Subba Reddy, Please find the link which Manish Provides the URL. Hope you will clear on this. And Thanks Manish for remind again

Re: Combo Chart

sunny_talwar — Thu, 20 Oct 2016 11:15:49 GMT

Slight improvement by moving the reference lines between the two bars

Re: Combo Chart

Anil_Babu_Samineni — Thu, 20 Oct 2016 11:17:46 GMT

Sunny, What you added from Reference Line?

Re: Combo Chart

nagarjuna_kotha — Thu, 20 Oct 2016 11:18:08 GMT

May be like this .

Check and let me know

-Nagarjun

Re: Combo Chart

subbareddykm — Thu, 20 Oct 2016 11:26:38 GMT

Hoiw to add reference line?

Re: Combo Chart

sunny_talwar — Thu, 20 Oct 2016 11:29:04 GMT

You will have to change your dimension to be a continuous dimension on the axis tab to be able to add vertical reference lines

Re: Combo Chart

sunny_talwar — Thu, 20 Oct 2016 11:31:12 GMT

Anil I don't understand your question, can you may be re-frame it for me?

Re: Combo Chart

nagarjuna_kotha — Thu, 20 Oct 2016 11:31:55 GMT

In presentation tab u can see reference line. u can add threre expressions.

I hope this may helps u

-Nagarjun

Re: Combo Chart

Anil_Babu_Samineni — Thu, 20 Oct 2016 11:40:35 GMT

Haha, I am asking you about Reference Line. I don't have license at this point. What you have done from there to get the Ref Lines. Hope Clear

Re: Combo Chart

sunny_talwar — Thu, 20 Oct 2016 11:44:10 GMT

1) Changed to continuous on the axis tab (as I mentioned in my above response to OP)

2) Once you enable continuous, you will see a third option becoming available within Reference lines

I hope that answers you question

Re: Combo Chart

MK_QSL — Thu, 20 Oct 2016 12:32:14 GMT

Anil babu

Multi Dimensional Bar Chart

Re: Combo Chart

subbareddykm — Fri, 21 Oct 2016 08:45:56 GMT

Sunny if i take dimention as a date instead of ID , my date field is not showing date it is showing as Number only that is becoz of continues option in axis tab.If i de slect that continues reference lines are now showing,

Is there any solution for it,?

Re: Combo Chart

sunny_talwar — Fri, 21 Oct 2016 10:29:30 GMT

Yes there is, got to the numbers tab and select Continuous X-axis and then use Date as Number Format settings