Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Reference line in combo chart ?

Hi Everyone,

I started Qlik Sense a week ago and was preparing a Pareto Chart using the Combo Chart, I wanted to show a reference line at 80% but couldnt find an option to do so. Is a Reference Line only available in a Bar Chart and not in a Combo Chart ? Or is there a way around this ?

Tags (2)
7 Replies
jyothish8807
Honored Contributor II

Re: Reference line in combo chart ?

Hi Muntazir,

Go to presentation tab in your graph and over there you will have Reference line box. Just add the value you want over there.

Regards

KC

Best Regards,
KC
Not applicable

Re: Reference line in combo chart ?

Hi Jyotish,

I guess you are referring to QlikView, i am asking about QlikSense. Below is the screenshot

Not applicable

Re: Reference line in combo chart ?

One workaround would be, adding the reference line values to the data model and using it as new measure on the chart.

Employee
Employee

Re: Reference line in combo chart ?

Hello Muntazir

You are correct - the reference line option is not available in the combo chart, I am not sure if it will be added, but I will inform our PM group.

In the mean-time - you can possibly calculate a trend or reference line using Qlik expressions. Check out the sample and solution to this post: http://community.qlik.com/message/590193

Let us know how you do.

Please mark the appropriate replies as correct or helpful so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Not applicable

Re: Reference line in combo chart ?

Hello Michael-  Do you know if the Reference Line functionality made it into the pipeline for the next release?  This is a very useful feature.  I have a set of incident data that I am working to visualize on a combo chart.  It will have the date of the incident and the length of time it took to resolve.  Is there a way to add a solid horizontal line to the chart showing the Mean Time to Resolution (i.e. Average incident length) over all the date dimensions.  Your equation referenced above almost gets there but I don't want trending.

Thanks for the help!

wizardo
Contributor III

Re: Reference line in combo chart ?

hi,

i know this post is very old, but seems my problem still isn't solved....?

The sample in the  link you mentioned was more about trend lines,

i am more interested in reference lines.

now, i know i can (and did) add another experssion as line and form it to be my value(f.e. 80%)

and that works fine.

the problem is that it is also effect by the color expression like the other measures.

so if i have different colors for ABC analysis, the 80% ref line needs to remain black.

so its a nice workaround.....but still would be nice to be able to have a place for a trend/reference line and sense will show it (ideally with a separated dynamic color expression

.....

or....may be there is, and i just don't know about it

Thank you

Daniel Chotzen

Digvijay_Singh
Honored Contributor III

Re: Reference line in combo chart ?

I was just browsing the latest QS feb release and I still don't see reference line in combo chart.

Did you request for this feature to Qlik support. they only provide new features if no of requests are significant from its customers.