topic Expresion wont work! in QlikView

Expresion wont work!

Wed, 15 Dec 2010 14:49:43 GMT

Im creating this Expressions and i cant get it to work.

sum({$<Offerte.Jaar={$(=Only(Offerte.Jaar))}>} ($(vNettoBedrag) )

The variable is like this : sum(OfferDetail.NETSALESAMOUNT) + sum(OfferMisc.NETSALESAMOUNT)

Any help?

Expresion wont work!

hector — Wed, 15 Dec 2010 14:54:57 GMT

Hi,

i think the problem is that you can't use sum( sum() ...), except if you use aggr() before the main sum()

check your formula, if this is valid change for


sum({$<Offerte.Jaar={$(=Only(Offerte.Jaar))}>} $(vNettoBedrag) )
And
vNettoBedrag = OfferDetail.NETSALESAMOUNT + OfferMisc.NETSALESAMOUNT

rgds

Expresion wont work!

Wed, 15 Dec 2010 15:05:51 GMT

Hey Hector thank you for your quick responce.

Using sum( sum( is indeed the problem. However if i change my variable to your suggested code i get a wrong result. The numbers go minus and one number skyrockets

Expresion wont work!

Wed, 15 Dec 2010 15:28:02 GMT

You will have to enclose it in an aggr like follow:

aggr(sum(OfferDetail.NETSALESAMOUNT) + sum(OfferMisc.NETSALESAMOUNT),Dimension1, dimension2)

Replace the Dimension1 etc with the dimensions you use in the chart.

This can then be used to sum with the other sum function.

Try this and when you get the result you can change the sums for a variable, remember that variables can return the string strange so double check it is expanded correctly.

//John

Expresion wont work!

Wed, 15 Dec 2010 15:51:51 GMT

Works Perfect Thank you!