Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
silvia_assuncao
Creator
Creator

Year Variation Problem

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,

Labels (1)
3 Replies
nicolett_yuri

Você deseja comparar os dados de um ano com o do ano anterior?

silvia_assuncao
Creator
Creator
Author

isto mesmo

Clever_Anjos
Employee
Employee

Já achou uma solução? Se sim, marque uma das respostas como "Correta" nos ajudando a manter os tópicos organizados.

Como obter ajuda? Leia antes de postar