Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting Trend line of a line chart in Qlik sense

Hi People. I am trying to use line chart which has trend line for different years. I want the different lines to be formatted differently- viz., dotted, chain, chain dotted etc. Is it possible to do it in Qlik sense? I know it can be done in Qlik view.

3 Replies
rospigliosi
Creator
Creator

Hi,

You need an extension for this.

You can try "Any Chart" on the Qlik Branch site.

balabhaskarqlik

May be this:

Can you try this link:

http://livingqlikview.com/how-to-reference-line-linear-trend-qlik-sense/

Can you try this Expression:

The expression below needs to be used and calculated as a new measure

linest_m(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate) *

only({1}OrderDate)+linest_b(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate)

Not applicable
Author

By trend line I meant line graph. So I don't want all the lines to be continuous so that people are able to distinguish between them even if they are not able to discern colors.

test.PNG