topic Re: graph problem in QlikView

graph problem

Tue, 11 Sep 2012 09:10:34 GMT

Hello everybody,

I have a problem with a chart that i have join for you!

The dimension are the month and the number of late week and my expression is:

=RangeSum((count(id_commessa) / count (total <Mois_année> id_commessa)), above([pourcentage_cumul]))

The expression is alright but when i didn't have data as september 2012 for 2 and 4 weeks late i want the valor equal to 100%

Have you got an idea to resolve that?

Thank you very much have a good day

Gysbert_Wassenaar — Tue, 11 Sep 2012 12:53:01 GMT

maybe this:

=RangeSum( if(isnull(id_commessa),1,(count(id_commessa) / count (total <Mois_année> id_commessa))), above([pourcentage_cumul]))

Tue, 11 Sep 2012 13:01:04 GMT

it doesn't work and i try

=RangeSum( if(isnull(count(id_commessa)),1,(count(id_commessa)/ count (total <Mois_année> id_commessa) )), above([pourcentage_cumul]))

and it doesn't work to!

i don't know if we resolve this problem a day!!!