topic accumulated current week / previous week with 2 dimensions in QlikView

accumulated current week / previous week with 2 dimensions

gr_eldred — Fri, 24 Nov 2017 05:40:06 GMT

Hi,

add the dimension Sem. Retail but my accumulated calculation of 6 weeks was broken.

before

now

my set analysis is

=num(sum({$<Status-={'C'}, Clasificación -={'Servicios','Refacciones','Pagos*','*Core value*'}, [Año Apple]={$(V_Año_Actual)} ,

[Trimestre Especial Numerico]={$(v_MaxTrimestreActual)}, SemanaAppleEspecial= {"<=$(v_MaxSemanaEsp)"}>} Cantidad_I)

Before(sum( {$<Status-={'C'}, SemanaAppleEspecial= {"<$(=Max(SemanaAppleEspecial))"}, Clasificación -={'Servicios','Refacciones','Pagos*','*Core value*'}, [Año Apple]={$(V_Año_Actual)} ,[Trimestre Especial Numerico]={$(v_MaxTrimestreActual)}, SemanaAppleEspecial= {"<$(v_MaxSemanaEsp)"}>}Cantidad_I))-1,'#,##0.0%')

can you help me?

Re: accumulated current week / previous week with 2 dimensions

gr_eldred — Fri, 24 Nov 2017 16:49:35 GMT

can you help me? Please

Re: accumulated current week / previous week with 2 dimensions

gr_eldred — Fri, 24 Nov 2017 17:05:53 GMT

I found the right solution would be like this.

=num(sum({$<Status-={'C'}, Clasificación -={'Servicios','Refacciones','Pagos*','*Core value*'}, [Año Apple]={$(V_Año_Actual)} ,[Trimestre Especial Numerico]={$(v_MaxTrimestreActual)}, SemanaAppleEspecial= {"<=$(v_MaxSemanaEsp)"}>} Cantidad_I)

Before(total sum( {$<Status-={'C'}, SemanaAppleEspecial= {"<$(=Max(SemanaAppleEspecial))"}, Clasificación -={'Servicios','Refacciones','Pagos*','*Core value*'}, [Año Apple]={$(V_Año_Actual)} ,[Trimestre Especial Numerico]={$(v_MaxTrimestreActual)}, SemanaAppleEspecial= {"<$(v_MaxSemanaEsp)"}>}Cantidad_I),1,2)-1,'#,##0.0%')