# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for
Did you mean:
Creator 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?

1 Solution

Accepted Solutions
Creator II
Author

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
Creator II
Author