Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
lejours88
Creator
Creator

Pie Chart or Gauge Chart

Hi,

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

I want to create a chart like this:

chart.png

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.

1 Solution

Accepted Solutions
avinashelite

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

View solution in original post

5 Replies
avinashelite

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 

lejours88
Creator
Creator
Author

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

avinashelite

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

View solution in original post

lejours88
Creator
Creator
Author

Wow,

thanks Avinash for your suggestion,

It solved my problem perfectly.

Thanks once again.

avinashelite

cool