Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Issue.

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

];Combo Chart Issue.PNG

13 Replies
Anil_Babu_Samineni

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

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
subbareddykm
Creator II
Creator II
Author

HI Anil ,

can you share the application ?

How did you do that ?

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
MK_QSL
MVP
MVP

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?