Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combo Chart


Hi QlikViewers

I am building a Combo Chart which should show me "Closed"," Lost" and "Abondoned" information by "Closed Date" (Bar Graph) and "Open" information by "Creation Date" (Line Graph). I can current see my bar graph accordingly but cannot see my "Open" information (Line Graph). Please see my attached app and assist.

1 Solution

Accepted Solutions
geert_gelade
Creator
Creator

Problem is "OPEN" vs "OPENED".

Try changing your line chart expression to "Sum(If(STATUS='OPENED',AMOUNT*IsOpp))" and in may the status OPEN will be visible.

View solution in original post

2 Replies
geert_gelade
Creator
Creator

Problem is "OPEN" vs "OPENED".

Try changing your line chart expression to "Sum(If(STATUS='OPENED',AMOUNT*IsOpp))" and in may the status OPEN will be visible.

Not applicable
Author

Oh my GOD...can't believe I missed that. Thanks a lot! It's the smallest things in life that gives us the worst headache...