How to show UP/DOWN symbols with LINEST function

[Anonymous]

Dear Qlik,

I have a data source and doing calculation for score.

  Now i want to show UP/DOWN symbols based on the trend  for 6 days.For this symbols i am using below expression of LINEST Function

=LINEST_M({<Date={">=$(=Date(Max(Date)-6))<=$(=Date(Max(Date)))"},Category={'Green'}>}
Aggr(Round((sum({<Date={">=$(=Date(Max(Date)-6))<=$(=Date(Max(Date)))"},Category={'Green'}>}Sales)/
sum({<Date={">=$(=Date(Max(Date)-6))<=$(=Date(Max(Date)))"},Category={'Green'}+{'Red'}+{'Yellow'}>} Sales)) *100,0.01),Date),Date)

Please give me a suggestion on this trend and symbols.

Thanks in advanced,

Regards

Suman