topic Re: Combo Chart with Vertical reference lines and Grouping for Phases. in QlikView

Issue.

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

Hi All ,

I have tried with Combo Chart with Vertical reference lines and Grouping for Phases.but no luck.

Can any one have any idea about this.

For reference plz check below screen shot and data.

For grouping i have shown Phase and data combination but ha does not satisfied with.

LOAD * INLINE [

Phase, Date, Sales, Bud, Profit

A, 1/2/2017, 30, 12, 0

A, 1/3/2017, 35, 15, 12

A, 1/4/2017, 40, 18, 24

A, 1/5/2017, 45, 21, 36

B, 1/6/2017, 50, 24, 48

B, 1/7/2017, 55, 27, 60

B, 1/8/2017, 60, 30, 72

C, 1/9/2017, 65, 33, 84

C, 1/10/2017, 70, 36, 96

C, 1/11/2017, 75, 39, 108

C, 1/12/2017, 80, 42, 120

C, 1/13/2017, 85, 45, 132

D, 1/14/2017, 90, 48, 144

D, 1/15/2017, 95, 51, 156

D, 1/16/2017, 100, 54, 168

E, 1/17/2017, 105, 57, 180

E, 1/18/2017, 110, 60, 192

];

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

subbareddykm — Wed, 12 Apr 2017 12:04:51 GMT

Can any one have any idea about it ?

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

Anil_Babu_Samineni — Wed, 12 Apr 2017 12:09:53 GMT

The main drawback is we can't take 2 dimensions with this control. Let him speak johnw

I think once upon a time mrkachhiaimp has given one example, As i know i have review only these two Legends. Wait some time, Will get response from them surely either +ve or -ve

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

MK_QSL — Wed, 12 Apr 2017 12:30:21 GMT

Is this what you are looking for?

Not exactly what you have requested. But tried to match as much as possible.

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

Anil_Babu_Samineni — Wed, 12 Apr 2017 14:31:47 GMT

As i assume, he expecting this? Correct me if i am wrong @subbareddykm

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

subbareddykm — Thu, 13 Apr 2017 03:19:12 GMT

Can u share the application,

In my requirement data Main Di mention and Phase is Secondary dim.

I observed u achieved lines for every pahse end. I want to implement that.

Plz share the app .

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

subbareddykm — Thu, 13 Apr 2017 04:09:26 GMT

one more thing , can you tell me how to get the vertical line for every phase end.?

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

Anil_Babu_Samineni — Thu, 13 Apr 2017 04:21:59 GMT

I even don't know about to do this. I've told to Manish which you need. That is it. Here, In that image i used only Line object as static.

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

MK_QSL — Thu, 13 Apr 2017 06:10:36 GMT

It near to impossible to get those reference lines dynamically.

I might be wrong but as far as I know this is not possible.

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

nagarjuna_kotha — Thu, 13 Apr 2017 06:42:01 GMT

Hi,

here i worked around it and got below output dynamic vertical lines.

Note : To get this u need to check continues option in Axis tab and one more thing group is not possible in this i guess.

Plz check attached file.

-Nagarjun

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

Anil_Babu_Samineni — Thu, 13 Apr 2017 06:53:13 GMT

Liked it, And good work around. But, coming to the use cases i mean next level for customer they won't understand easily as much we are proving. When Phase comes to the picture on X-Axis that's good to have even work around like below. I used Slider object for Phase to get in. Analysis more easy to get

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

subbareddykm — Thu, 13 Apr 2017 06:58:30 GMT

HI Anil ,

can you share the application ?

How did you do that ?

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

Anil_Babu_Samineni — Thu, 13 Apr 2017 07:39:10 GMT

Create Slider style and and select data field as Phase then click okay. You will get idea and drag to the same place where you want

Re: Combo Chart with Vertical reference lines and Grouping for Phases.

MK_QSL — Thu, 13 Apr 2017 07:43:03 GMT

This is not dynamic. In case new phase come say X, Y, Z etc how to tackle them?

Also we need to provide only one expression for reference line instead of as many as number of phases. In case we have 100 phase, should we created 100 expressions?