Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

graph problem

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

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

maybe this:

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


talk is cheap, supply exceeds demand
Not applicable
Author

hi gwassenaar,

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!!!

Thanks gwassenaar