topic Re: Calculation of variation for 2 years in QlikView

Calculation of variation for 2 years

jose_vargas — Sat, 16 Nov 2024 02:41:26 GMT

Hi Community.

This time I am writing because I have a problem to calculate the variation in a table.

The formula is not a problem. My problem is that I need the variation of only 2 years to be shown, even if I have selected more than years. For example on my sheet I have selected the years 2015, 2016, 2017 and 2018 ... I just need to show the variation from 2017 to 2018.

Re: Calculation of variation for 2 years

aslam24196 — Wed, 21 Aug 2019 04:53:57 GMT

Hi Jose,

You can use set analysis to restrict the Year to be considered for Expression.

Assuming the formula You have used is Sum(Variance).

You can instead Use Sum({<Year={2017,2018}>}Variance) to display only for 2017 and 2018.

Re: Calculation of variation for 2 years

jmartineze — Wed, 21 Aug 2019 12:39:27 GMT

hi, try with Sum({<Year={$(=max(Year)),$(=max(Year)-1)}>} FieldName ) and select the chart option detach.

Re: Calculation of variation for 2 years

jose_vargas — Wed, 21 Aug 2019 14:39:05 GMT

Hi.. Its Works, but the value show in all years like a 0. How I do to hide the value from the every year less tnah the last.... Need to show the calculation in the las column.

thanks

Re: Calculation of variation for 2 years

jose_vargas — Wed, 21 Aug 2019 15:47:49 GMT

Community... Im using the "max" for the field year.

For example Im calculate the sum from the max year in my case is "2019", and only show values in this year, because this sentence works like a "IF".

Sum( {$<Año={'$(=Max(Año))'}>} Cantidad_Transito)

How I do, to show this value for all the year, I mean, that the calculate from 2019 have to show in the other years.. .Something like this.

Thanks a lot.

Re: Calculation of variation for 2 years

jmartineze — Wed, 21 Aug 2019 17:45:50 GMT

Puedes quitar el año como dimensión y añadir tantas expresiones como necesites, utilizando el set análisis controlas las expresiones para cada año.