How to show UP/DOWN symbols with LINEST function

Anonymous — Mon, 15 Oct 2018 07:18:30 GMT

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

topic How to show UP/DOWN symbols with LINEST function in QlikView

How to show UP/DOWN symbols with LINEST function