Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
caovanhau1507
Contributor
Contributor

Impact Point on Index

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:

Capture.JPG

 

 

 

However, I cannot use this to accumulate by Dates.

Please help me!

Many thanks!

0 Replies