Below or before Qlikivew

cristianj23a — Wed, 25 Nov 2020 16:16:04 GMT

Hi.

Mainly I have a table with the CESADOS and ACTIVOS columns.

Then we divide CESADOS / ACTIVOS.

But there was a case, that CESADO has to go back one row to do the calculation CESADO / ACTIVOS.Use the BELOW () sentence,

to go back une row in CESADO.

So far so good, but when I select a day, no value appears. example

Select:

Mes: ene

Día:4

must be obtained.

I am using the BELOW () statement so that the values of CESADOS, go back one day or row.

Please help me get that value when I select a day.

Like when I select a Month, would like to obtain the average of Assets, Cesados and the percentage.

Mes = 'ene'

The average is

CESADOS = 49

ACTIVOS = 8291

Below(CESADO)/ACTIVO = 0.60%

I attach the Qvw y Xls.

Re: Below or before Qlikivew

sunny_talwar — Fri, 19 Jan 2018 20:46:26 GMT

Seems like the same question as this

Check my response in that post