YTD percentage

[BlakeGri2093]

Hello qlik sense family

i wondering how to calculate the YTD growth ?, please help me with this case

[pradosh_thakur]

1-(Column(1)/above(column(1)) may be

the logic is to access the previous value using above() function.

[Channa · Accepted solution]

(Sum(Sales)/Above(Sum({<Year>}Sales)) - 1) * Avg(1)

try

[BlakeGri2093]

thanks a lot, it works