Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

Two years product wise Difference

Hi Friends,

I'm having years 2012,2013,2014 and products.

I need to find the difference for the 2014 and 2013 product wise in the percentage.

Need to show the Difference column at below years.

Please ,find the below attachment for the sample application and guide me further.

Thanks & Regards

Krishna

3 Replies
arulsettu
Master III
Master III

HI

try this

sum({<year = {2014}>}products/sum({<year = {2013}>}products

krishna20
Specialist II
Specialist II
Author

Hi Anil,

Thank You for your valuable reply.

Here i have taken the products in Calculated dimension.

Please find the below image.i need to show like this

Regards

Krishna

krishna20
Specialist II
Specialist II
Author

Sample File