topic Re: Gauge Chart in QlikView

Gauge Chart

Wed, 12 Aug 2015 23:49:08 GMT

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

Re: Gauge Chart

sunny_talwar — Thu, 13 Aug 2015 04:46:36 GMT

No Dimension and this as your expression:

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

Re: Gauge Chart

jafari_ervin — Thu, 13 Aug 2015 05:28:49 GMT

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

Re: Gauge Chart

jafari_ervin — Thu, 13 Aug 2015 05:29:19 GMT

Please share your sample qlikview file.