Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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.