QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Highlighted
Contributor II

accumulated current week / previous week with 2 dimensions

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?

Tags (4)
1 Solution

Accepted Solutions
Contributor II

Re: accumulated current week / previous week with 2 dimensions

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%')

2 Replies
Contributor II