Data = 0

[pgalvezt]

Hello,

I have a table with many departments and values by Accounts and Cc. I need to appears the other values. When I do clic on 31020301 QlikView Shows 0. Same thing with 31020302. For 31020303 the formula works fine. But I need the other values.

Thanks!!

[sunny_talwar]

The qvw is asking for User Identification

Please give the User ID or re-add another version of qvw.

Best,

Sunny

[pgalvezt]

Sorry,

Now goes without User Identification

[sunny_talwar]

You have specified it in your expression that only when Cuenta is 31020303, display a result. Why did you add it there?

(Sum(Aggr(If(Cuenta='31020303' and Cc='4407',Sum({<Año={'2015'}>}MONTO*-1)*0.7513, Sum({<Año={'2015'}>}MONTO*-1)),Cc)))-

(Sum(Aggr(If(Cuenta='31020303' and Cc='4400',Sum({<Año={'2015'}>}MONTO*-1)),Cc)))-

(Sum(Aggr(If(Cuenta and Cc,Sum({<Año={'2015'}>}MONTO*-1)),Cc)))

[sunny_talwar]

What is the output that you are expecting to see?

[pgalvezt]

Is an excel requirement. I have the same account but with 2 different Cc. So the formula in excel is

=(Range in excel) - 'Sheet'!File*0,7513)*-1

everything else must be the same values that in excel.

[pgalvezt]

Sum({<Año={'2015'}>}MONTO*-1)

This formula allow you see all data. Was the initial formula. I have to change it because people ask for a new requeriment.

[sunny_talwar]

What was the new requirement that made you change the formula?

May be that will help resolve the issue

Best,

Sunny

[pgalvezt]

(Sum(Aggr(If(Cuenta='31020303' and Cc='4407',Sum({<Año={'2015'}>}MONTO*-1)*0.7513, Sum({<Año={'2015'}>}MONTO*-1)),Cc)))-

(Sum(Aggr(If(Cuenta='31020303' and Cc='4400',Sum({<Año={'2015'}>}MONTO*-1)),Cc)))-

(Sum(Aggr(If(Cuenta and Cc,Sum({<Año={'2015'}>}MONTO*-1)),Cc)))

The reuirement is that accoount 31020303 and Cc 4407 must be * by 0.7513, then Range - (that accoount 31020303 and Cc 4407 must be * by 0.7513)

Range means Sum({<Año={'2015'}>}MONTO*-1)

[sunny_talwar]

Is this the goal:

If(Cuenta='31020303' and Cc='4407' then do this: Sum({<Año={'2015'}>}MONTO*-1)*0.7513

otherwise do this: Sum({<Año={'2015'}>}MONTO*-1)