Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Honored Contributor III

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

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
Honored Contributor

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

Hi,

May be

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


Regards,

Andrey

Not applicable

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

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

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

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

Community Browser