topic Re: Pie Chart or Gauge Chart in QlikView

Pie Chart or Gauge Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a question, i have a data consists of 3 column (GROUP, BRAND, QUANTITY)

I want to create a chart like this:

i want to calculate the percentage of Group. Sum(Quantity)/Sum(total Quantity) %

Is it possible to create that kind of chart ?

I also attach my sample data.

thanks in advance.

Re: Pie Chart or Gauge Chart

avinashelite — Mon, 07 Mar 2016 07:32:02 GMT

Yes its possible, I would suggest use Pie chart for the same. But note you can use a max of 2 dimension so that the chart representation would be clear

Re: Pie Chart or Gauge Chart

Anonymous — Mon, 07 Mar 2016 07:35:14 GMT

Hi Avinash,

Thanks for reply.

Yes i only use one dimension (GROUP dimension).

I've try using pie chart. but is it possible to separate each group like that ?

Thanks

Re: Pie Chart or Gauge Chart

avinashelite — Mon, 07 Mar 2016 07:37:48 GMT

Yes its possible .

Go to the Expression Tab. Under the Expression you created, there is + sign , expand this and you will see a Pie Popout option. Select this option and enter an expression such as sum(your expression) > 0 or simply add 1

Re: Pie Chart or Gauge Chart

Anonymous — Mon, 07 Mar 2016 07:40:50 GMT

Wow,

thanks Avinash for your suggestion,

It solved my problem perfectly.

Thanks once again.

Re: Pie Chart or Gauge Chart

avinashelite — Mon, 07 Mar 2016 07:50:54 GMT

cool