Gauge Chart

[#1]

This may seem like a trivial question so please bare with me. I am trying to create a gauge chart based simply on 2 pieces of data to display the status of a project. Essentially, there are 50 tasks, and 25 have been completed. So, project would 50% complete. So currently I have (Activity) = 98 and (Activity Complete) = 54.

After selecting the gauge chart, I'm not sure what to include in the Dimension Field and the expression field. Any help would be appreciated.

Thanks,

Kevin

[sunny_talwar]

No Dimension and this as your expression:

=Count({<[Project Status] = {'Activity Complete'}>} [Project Status]) / Count([Project Status])

[jafari_ervin]

There is no need to select any dimension for guage if you want to show one ratio, but if you want to show the rate of each project you need to add your project inthe dimension.currently you you need to know Set analysis to write the conditional formula.

Best

[jafari_ervin]

Please share your sample qlikview file.