Compare relative stock performace

[#1]

Hi everybody and thank you for this great community.

I want to compare two different stocks in a dynamic Chart. The solution should not be scriptbased.

Therefore it is neccessary to set the first Course of each stock to 100.

For a better understanding i created an excelsheet.

If it is not to complicated, can anyone help me with the implemetation in qlikview?

[eduardo_sommer · Accepted solution]

See attached file, where the expressions used were

only(CourseStock1)/FirstSortedValue(total CourseStock1,Date)*100  and

only(CourseStock2)/FirstSortedValue(total CourseStock2,Date)*100

Regards

Eduardo