topic Re: Re: Two years product wise Difference in QlikView

Two years product wise Difference

krishna20 — Thu, 06 Nov 2014 06:54:37 GMT

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

arulsettu — Thu, 06 Nov 2014 07:03:40 GMT

try this

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

krishna20 — Thu, 06 Nov 2014 07:31:26 GMT

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 — Thu, 06 Nov 2014 07:47:03 GMT

Sample File