Error Calculating variation by year

silvia_assuncao — Thu, 21 Jan 2016 17:46:26 GMT

Hi,

I Have a problem when calculating variation between years.

I have 3 charts, Chart 1 and 2 the values are correct, but the chart 3 does not bring right values (value for chart 3 should be the same as chart 2.

Expression for Chart 2

(Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
- (Above(Total ((Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
)),Count(DISTINCT Total<Year> [Year]))))

This is teh expression I'm using: and the result is not right.

(Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
- (Above(Total ((Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
)),Count(DISTINCT Total<Year> [Company Code]))))

Could you please help me with this?

best regards,

Re: Error Calculating variation by year

Thu, 21 Jan 2016 19:54:29 GMT

The reason may be you don't have Company_Code in your Dimension list.

Re: Error Calculating variation by year

silvia_assuncao — Thu, 21 Jan 2016 21:56:19 GMT

As a matter of fact, I do thave the Company_Code listed as dimension in chart 3. but the values returned are not correct. values should be the same as chart 1

topic Re: Error Calculating variation by year in QlikView

Error Calculating variation by year

Re: Error Calculating variation by year

Re: Error Calculating variation by year