Creating a % Growth/ Loss in Table for different years

[neerajthakur]

Hi, @sunny_talwar I hope you can help me in this with your expertise.

I want to create something similar to above in qliksense calculating %Growth, I have tried something similar but the results get affected by sorting, I will be using this expression for count calculation : count({<Year={'20xx'}>} distinct ref_id) for every year.

[Mario_De_Felipe]

Hi @neerajthakur 

Using an straight table:

1. Set Year as dimension
2. Set Count expression as count(distinct ref_id)
3. Set % Growth expression as RangeSum([Count],-above([Count]))/above([Count])

Best regards