Impact Point on Index

caovanhau1507 — Wed, 11 Dec 2019 08:15:45 GMT

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!

topic Impact Point on Index in App Development