Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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