topic Re: Function Weekname in QlikView

Function Weekname

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

Dear Sirs, I have stated the following script and I need to do a calculus with last week data.

fechas:
LOAD Distinct
fecha_union,
year (fecha_union) as Año,
Month (fecha_union) as Mes,
day(fecha_union) as Dia,
MonthName (fecha_union) as Periodo,
Num#(date (fecha_union, 'YYYYMM')) as PeriodoNum,
Week(fecha_union) as Semana,
Weekname(fecha_union) as Numero_Semana,
date(fecha_union) as fecha
Resident union;

I stated the following variables

vSemanaMax= Max(Numero_Semana)

vSemanaMax_m1 = Max(Numero_Semana)-1

Then the following expression, gives me a null result

sum({<Año=, Mes=, fecha=, PeriodoNum=, Numero_Semana={$(vSemanaMax)}>}numerador_icf) / sum({<Año=, Mes=, fecha=,PeriodoNum=, Numero_Semana = {$(vSemanaMax)}>} denominador_icf)

Where is the problem?

Thanks in advance

Re: Function Weekname

sunny_talwar — Fri, 02 Dec 2016 16:21:07 GMT

Try your variables like this

vSemanaMax= WeekName(Max(fecha_union));

vSemanaMax_m1 = WeekName(Max(fecha_union)-7);

Re: Function Weekname

ale_nilo84 — Fri, 02 Dec 2016 16:38:00 GMT

Ok I changed the variables, now it appears this following error.

Should I fix the expression?

sum({<Año=, Mes=, fecha=, PeriodoNum=, Numero_Semana={$(vSemanaMax)}>}numerador_icf) /sum({<Año=, Mes=, fecha=,PeriodoNum=, Numero_Semana = {$(vSemanaMax)}>} denominador_icf)

Re: Function Weekname

sunny_talwar — Fri, 02 Dec 2016 16:44:34 GMT

May be add your variable within single quotes like this and add = sign within the dollar sign expansion

Sum({<Año=, Mes=, fecha=, PeriodoNum=, Numero_Semana={'$(=vSemanaMax)'}>}numerador_icf) /Sum({<Año=, Mes=, fecha=,PeriodoNum=, Numero_Semana = {'$(=vSemanaMax)'}>} denominador_icf)

Re: Function Weekname

ale_nilo84 — Fri, 02 Dec 2016 18:49:09 GMT

Great!!, it works fine now,

What is the function of the single quotes?

Re: Function Weekname

sunny_talwar — Sat, 03 Dec 2016 03:07:55 GMT

You will be able to find all the information here:

A Primer on Set Analysis