topic Re: Total Problem (Pivot Table) in QlikView

topic Re: Total Problem (Pivot Table) in QlikView https://community.qlik.com/t5/QlikView/Total-Problem-Pivot-Table/m-p/1438800#M431923 <HTML><HEAD></HEAD><BODY><P>Thank you very much, works perfectly!</P></BODY></HTML> Wed, 11 Oct 2017 18:42:07 GMT pgalvezt 2017-10-11T18:42:07Z Total Problem (Pivot Table) https://community.qlik.com/t5/QlikView/Total-Problem-Pivot-Table/m-p/1438798#M431921 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a problem when I change the filter selection from 'A' to 'B', I tried to change the aggregation formula but until now it doesn´t work,</P><P></P><P>I attached a little example. All what I want is the real sum when the selection is 'B'. 'A' Works fine.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 11 Oct 2017 18:22:32 GMT https://community.qlik.com/t5/QlikView/Total-Problem-Pivot-Table/m-p/1438798#M431921 pgalvezt 2017-10-11T18:22:32Z Re: Total Problem (Pivot Table) https://community.qlik.com/t5/QlikView/Total-Problem-Pivot-Table/m-p/1438799#M431922 <HTML><HEAD></HEAD><BODY><P>Can you check if this works</P><P></P><P><STRONG>=Num(</STRONG></P><P><STRONG>Sum(Aggr(If(MarcaUF = 'B' and Pais = 'Chile',</STRONG></P><P><STRONG>If(Cod_Tipo_Monto = 'Bruto',</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Chile'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Chile'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0')),</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe_IVA)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Chile'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_IVA_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Chile'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0'))),</STRONG></P><P></P><P></P><P><STRONG>If(MarcaUF = 'B' and Pais = 'Colombia',</STRONG></P><P><STRONG>If(Cod_Tipo_Monto = 'Bruto',</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Colombia'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Colombia'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0')),</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe_IVA)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Colombia'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_IVA_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Colombia'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0'))),</STRONG></P><P></P><P></P><P><STRONG>If(MarcaUF = 'B' and Pais = 'México',</STRONG></P><P><STRONG>If(Cod_Tipo_Monto = 'Bruto',</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'México'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'México'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0')),</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe_IVA)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'México'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_IVA_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'México'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0'))),</STRONG></P><P></P><P></P><P><STRONG>If(MarcaUF = 'B' and Pais = 'Perú',</STRONG></P><P><STRONG>If(Cod_Tipo_Monto = 'Bruto',</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Perú'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Perú'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0')),</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe_IVA)*Aggr(sum({<Mes={$(xaMesMax)},Año={$(xAñoMax)},Pais={'Perú'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_IVA_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)},Pais={'Perú'}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0'))),</STRONG></P><P></P><P></P><P><STRONG>If(Cod_Tipo_Monto = 'Bruto',</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0')),</STRONG></P><P><STRONG>If(vCurrency='CLP',Num(Sum(Importe_IVA)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),</STRONG></P><P><STRONG>Num(Num(Sum(Importe_IVA_TC)*Aggr(sum({<Mes={$(xMesMax)},Año={$(xAñoMax)}>} Distinct Total ValorUF),Local2) /Divisor,'$ #.##0;-$ #.##0'),'US$ #.##0;-US$ #.##0'))))))), Pais)),</STRONG></P><P><STRONG>If(GetFieldSelections(Seleccionar_Currency) = 'CLP', '$ #.##0;-$ #.##0', 'US$ #.##0;-US$ #.##0'))</STRONG></P></BODY></HTML> Wed, 11 Oct 2017 18:30:02 GMT https://community.qlik.com/t5/QlikView/Total-Problem-Pivot-Table/m-p/1438799#M431922 sunny_talwar 2017-10-11T18:30:02Z Re: Total Problem (Pivot Table) https://community.qlik.com/t5/QlikView/Total-Problem-Pivot-Table/m-p/1438800#M431923 <HTML><HEAD></HEAD><BODY><P>Thank you very much, works perfectly!</P></BODY></HTML> Wed, 11 Oct 2017 18:42:07 GMT https://community.qlik.com/t5/QlikView/Total-Problem-Pivot-Table/m-p/1438800#M431923 pgalvezt 2017-10-11T18:42:07Z