topic Re: Setting the previous year in set analysis in QlikView

Setting the previous year in set analysis

Ribeiro — Mon, 15 Jan 2018 12:38:40 GMT

I need to go back the previous year in the variable?

vMesAtual = Makedate(year(today()),month(today()),25);

vMesAnt = Makedate(year(today()-30),month(today()-30),25);

I need to fix the variable to bring 12/25/2017 = vMesAnt

But the variable must always be on the 25th of every month

Example:

vMesAnt : 25/12/2017

vMesAtual: 25/01/2018

any suggestion?

Re: Setting the previous year in set analysis

sunny_talwar — Mon, 15 Jan 2018 12:40:49 GMT

May be this

vMesAtual = MakeDate((Year(Today()) - 1), Month(Today()), 25);

vMesAtual = MakeDate(Year(AddYears(Today(), -1)), Month(Today()), 25);

Re: Setting the previous year in set analysis

PrashantSangle — Mon, 15 Jan 2018 12:40:59 GMT

Use addYear(YourExpression,-1)

Regards

Re: Setting the previous year in set analysis

Ribeiro — Mon, 15 Jan 2018 12:42:47 GMT

If the date is 2/25/2018 and 1/25/2018 will it work?

Re: Setting the previous year in set analysis

sunny_talwar — Mon, 15 Jan 2018 12:45:01 GMT

Oh, you want to go just one month back? Try this

vMesAnt = AddMonths(MakeDate(Year(Today()), Month(Today()), 25), -1);

Re: Setting the previous year in set analysis

YoussefBelloum — Mon, 15 Jan 2018 12:45:45 GMT

Hi, try this

vMesAnt = Makedate(AddYears(today(),-1),month(today()-30),25);

Re: Setting the previous year in set analysis

Ribeiro — Mon, 15 Jan 2018 12:48:57 GMT

Thanks for your patience and competence.

Re: Setting the previous year in set analysis

Ribeiro — Mon, 15 Jan 2018 13:03:37 GMT

Sunny will be that the set analys is correct?

It is not bringing values...

vMesAtual = Makedate(year(today()),month(today()),25);

vMesAnt = AddMonths(MakeDate(Year(Today()), Month(Today()), 25), -1);

Sum({$<Ano =,Mes=,Date1 = {">= $(vMesAnt) <= $(vMesAtual)"},

[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final)

Re: Setting the previous year in set analysis

sunny_talwar — Mon, 15 Jan 2018 13:05:39 GMT

Don't add spaces and then try this

Sum({$<Ano =,Mes=,Date1 = {">=$(=vMesAnt)<=$(=vMesAtual)"},

[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final)

or this

Sum({$<Ano =,Mes=,Date1 = {">=$(=$(vMesAnt))<=$(=$(vMesAtual))"},

[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final)

Re: Setting the previous year in set analysis

Ribeiro — Mon, 15 Jan 2018 13:08:28 GMT

Sum({$<Ano =,Mes=,Date1 = {">=$(=vMesAnt)<=$(=vMesAtual)"},

[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final)