topic chart problem in QlikView

chart problem

Thu, 14 Mar 2013 10:53:34 GMT

Hello everybody,

I have a little problem with the expression of my chart. I want to have the total of my expression 'IS' but with aggr() fonction it doesn't work! (I think it's because I have a log() in my expression!?).

I want to have the total in total case or in all case as my precedent expression. I have the same problem for the two charts of my qvw.

I put my qvw in attach, perhaps you can help me?

Thank you a lot and have a good day

Budny Quentin

Re: chart problem

Gysbert_Wassenaar — Thu, 14 Mar 2013 11:00:08 GMT

Try:

=sum(aggr((( sum(comptage)/sum(total <lib_var,MOI_DEC>comptage)) - sum(valeur_calcul) )

log( ( sum(comptage)/sum(total <lib_var,MOI_DEC>comptage) ) / sum(valeur_calcul) )

,lib_var

,valeur

,valeur_calcul

,MOI_DEC))

Re: chart problem

Thu, 14 Mar 2013 12:02:49 GMT

Beautifull Gisbert,

It's exactly what i want!!!!!

Thank you so much,

Quentin