topic Re: And Like Add in QlikView

And Like Add

pgalvezt — Thu, 11 Oct 2012 19:40:54 GMT

Hi, I have this formula:

=((Sum(If(Cod_Bloqueo <> 8 And Tramos = 'Tramo 1', Deuda_Total*Porc_Provision))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))

((Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))

Works fine...

But

I need to add a new Tramos

=((Sum(If(Cod_Bloqueo <> 8 And Tramos = 'Tramo 1' And Tramos = 'Tramo 2', Deuda_Total*Porc_Provision))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))

((Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))

But when I did the filter gave me a different result. Maybe the AND is bad?

Thank You!

Re: And Like Add

MayilVahanan — Thu, 11 Oct 2012 19:49:12 GMT

Do you want Tramos filed contain both 'Tramo 1' and 'Tramo 2', then your expression correct.. I think for that particular filter selection may be its not satisfy both the Tramos condition..Please check the data..

Re: And Like Add

pgalvezt — Thu, 11 Oct 2012 19:57:05 GMT

Thank you for yor reply

I have 6 tramos. I can get the good result with just 1 Tramo but when I trie to add another Tramo Gave me another Result when I do the filter.

Re: And Like Add

MayilVahanan — Thu, 11 Oct 2012 20:08:27 GMT

For a same filter , did u tested the result for tramo1 alone and both tramo1 and tramo2 ?? If so, please you use the table box and give the test filters and tramo and noted that contain both values.. if not, then its show the different results..

Use OR instead of AND..May be its give... Can you explain your requirement once..

Re: And Like Add

pgalvezt — Thu, 11 Oct 2012 20:37:45 GMT

I tried another formula with set Analysis:

=(Sum({<Credito_Consumo,Tramos_Consumo>} (Saldo_Insoluto_Consumo)*Porc_Provision_Consumo)/Divisor)/(Sum(Saldo_Insoluto_Consumo)/Divisor)

When I do the filter with any Tramos gave me a good result:

But

=(Sum({<Credito_Consumo,Tramos_Consumo={'Tramo 0'}>} (Saldo_Insoluto_Consumo)*Porc_Provision_Consumo)/Divisor)/(Sum(Saldo_Insoluto_Consumo)/Divisor)

Gave: "No data to show"

What can be?

Thanks

Re: And Like Add

MayilVahanan — Thu, 11 Oct 2012 20:44:25 GMT

Can you able to post a sample file?

Try with this

=(Sum({<Credito_Consumo = ,Tramos_Consumo={'Tramo 1'}>} (Saldo_Insoluto_Consumo)*Porc_Provision_Consumo)/Divisor)/(Sum(Saldo_Insoluto_Consumo)/Divisor)

if you get the result for above expression then please check the data for Tramos_Consumo

Re: And Like Add

pgalvezt — Thu, 11 Oct 2012 20:50:24 GMT

=(Sum({<Credito_Consumo = ,Tramos_Consumo={'Tramo 1'}>} (Saldo_Insoluto_Consumo)*Porc_Provision_Consumo)/Divisor)/(Sum(Saldo_Insoluto_Consumo)/Divisor)

Gave me 0,1 % the real result is 56% When I did the filter. The weight of my QV Model is of 300 MB is impossible send to you a sample