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
