Trend should show symbols

[rkpatelqlikview]

Dear Qlik,

PFA qvw. Can any one solve to show symbol in trend analysis in bar graph. Any one of them should display out of 3.

Thanks for your support.

[sunny_talwar · Accepted solution]

Check the attached where I created a variable with Linest_M function

=LINEST_M(Aggr(Round(Sum({ < [Safety Category] ={'Green'},WEEK= {">=$(=MAX(WEEK)-5)"}>}[Kms Travelled])/sum({<WEEK= {">=$(=MAX(WEEK)-5)"}>}[Kms Travelled])*100), WEEK), WEEK)

and then based of the value, we can decide if the increase, decrease or stable image shows up

[rkpatelqlikview]

Thanks Sunny. Great help.