Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gr_eldred
Creator II
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

acum 1.png

now


acum2.png

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
gr_eldred
Creator II
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%')

View solution in original post

2 Replies
gr_eldred
Creator II
Creator II
Author

can you help me? Please

gr_eldred
Creator II
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%')