How to create a vertical reference line based accumulation

[narayanamsn]

Hi all,

I have a question related to reference line based on accumulation.

Item	Price
a	20
b	25
c	35
d	15
e	18
f	10

Plotted an Bar chart with the price and wanted to highlight once the accumulated price reaches 100 as shown in the attached graph.

Can anyone help me with the expression that uses the summed up prices to draw reference lines for the 100 $s?

[tunoi]

i dont think that is possible in Qlikview.

Some alternative:

[narayanamsn]

Thank you Ionut Bostan.

I know this trick..but I am trying for other scenario that I mentioned. Looking for some tweaks..

[vinieme12]

it's only possible with a continuous x axes

Vertical Reference Lines