Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
Contributor

Re: Formatting Trend line of a line chart in Qlik sense

Hi,

You need an extension for this.

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

balabhaskarqlik
Honored Contributor

Re: Formatting Trend line of a line chart in Qlik sense

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

Re: Formatting Trend line of a line chart in Qlik sense

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

Community Browser