Reference line in Qlikview stacked bar chart

[konidena]

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

[adamdavi3s]

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]

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

hope this helps

[konidena]

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]

see attached