Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

stacked bar chart with reference line (kind of)

Hi all,

is it possible to have a reference line similar to the one in the attached chart?

about the chart:

horizontal stacked car chart,

dimension = geographic address and Time

expression = 1/60 to represent minutes

bar colour expression = avg(speed)

the chart is uses the colour of the bar to represent speed each minute across the day and select location.

now what i would like is a reference line (or similar) that for example starts at 10 oclock at site M55/5248K and ends at  2 oclock.

is this possible?

kindest,

5 Replies
Highlighted
Master
Master

Re: stacked bar chart with reference line (kind of)

So do you want a vertical line at 10 and another at 2?

If so then you should just be able to define a couple of reference lines as normal (I think!)

Highlighted
Creator III
Creator III

Re: stacked bar chart with reference line (kind of)

Hi

You can add reference line in bar graph under Presentation in reference line section based on the condition, refer screen shot below for info.

Hope this help

Untitled.png

Highlighted
Creator
Creator

Re: stacked bar chart with reference line (kind of)

Hi all,

thanks for the responses, im familiar with the reference lines however if you look in the image this isnt quite what im after.

its not looking like its possible without an extension i was wondering if anyone had any ideas,

Highlighted
Master
Master

Re: stacked bar chart with reference line (kind of)

Sorry that was a part of my response, the image doesn't really make it clear what you're after.

So its not a line at 10 and 2, do you want to fill each bar with red between 10 and 2?

Highlighted
Creator
Creator

Re: stacked bar chart with reference line (kind of)

my apologies.

abit of background to explain a little better.

the chart represents speed along a road, at various locations there are message signs that switch on and off at certain points. i want my line to represent them switching on and off.

i could change the colour of the bar to represent this however im working to a spec and have to deliver certain functionality.