Hi all,
I try to calculate the impact point on Index by using formula:
In Qlik, I calculate the impactation in 1 Date by expression:
(Listed*Price/sum({$<StockType={'STOCK'}>}total Listed*Price))
*fabs(Price/PriorPrice-1)*max({$<StockID={'VNINDEX'}>}total Price)
the chart:
However, I cannot use this to accumulate by Dates.
Please help me!
Many thanks!