Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
konidena
Creator
Creator

Reference line in Qlikview stacked bar chart

Hi Team,

I need help here.

I have the stacked bar chart.

Dimension is valuelist('Renewal', 'New' 'Total')

Expression:

Pick(Match(valuelist('Renewal','New' 'Total'),'Renewal', 'New' 'Total'),

Expresison for Renewal,

Expression for New,

Column for Total is Renewal + New

Now, I have to show the a horizontal line on top of Each stacked bar

Stacked bars are "Renewal","new", "Total".

Attached the appearance of the chart. Please tell me if any logic is there to display the same format.

Regards

Srinivas

4 Replies
adamdavi3s
Master
Master

Currently you can't use a line as a 'symbol' but there are some ideas here:

'Line' as a Symbol for Combo-Charts | Qlik Community

Frank_Hartmann
Master II
Master II

Have a look at the attached sample as a possible starting point.

hope this helps

konidena
Creator
Creator
Author

Thanks Frank. But I don't have the direct dimension. Hence, I used value list function to create the values "Renewal, New, Total" for the Respective bars.

From your application , I found that you used the dimension which is created from Inline table.

I am not able to achieve this functionality.

Thank you.

Frank_Hartmann
Master II
Master II

see attached