Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
gr_eldred
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

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

View solution in original post

2 Replies
gr_eldred
Contributor II

Re: accumulated current week / previous week with 2 dimensions

can you help me? Please

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

View solution in original post