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: 
Not applicable

How can I calculate the increase in sales year by year?

Dear,

I need help to calculate the increase in sales [Oportunidad.PrecioCliente] year by year [OpDetalle.FechaCierre.autoCalendar.Year] for each product. I have the following table:

2a6b058c62954b19a13e2685c3ac04a2.png

I set the following function but it does not calculate any value

Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={[OpDetalle.FechaCierre.autoCalendar.Year]}>}[Oportunidad.PrecioCliente])/

Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={[OpDetalle.FechaCierre.autoCalendar.Year]}-1>}[Oportunidad.PrecioCliente])

How should I write the formula?

How can I calculate the increase in sales year by year?

Thanks!

4 Replies
arulsettu
Master III
Master III

try this

Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={$(=(max([OpDetalle.FechaCierre.autoCalendar.Year]))}>}[Oportunidad.PrecioCliente])/

Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={$(=max([OpDetalle.FechaCierre.autoCalendar.Year])-1)}>}[Oportunidad.PrecioCliente])

ahaahaaha
Partner - Master
Partner - Master

Hi,

May be

Sum([Oportunidad.PrecioCliente])/Above([Oportunidad.PrecioCliente], 1, 1)


Regards,

Andrey

Not applicable
Author

Thanks Andrey, but I need the increase year by year.

The formula performs the calculation only for the year 2017.

Is the table wrong how I designed it?

Año is a Dimension

Brand is a Dimension

Ventas is a Meassure

Qlik-Help_001.png

Not applicable
Author

Thanks Arul,

The formula does not return any results. Is the table wrong how I designed it?

Año(Year) is a Dimension

Brand is a Dimension

Ventas(Sales) is a Meassure

Qlik-Help_002.png