topic Re: How to create a pie chart in qlikview in QlikView

How to create a pie chart in qlikview

Mon, 12 Jan 2015 14:39:40 GMT

Hello,

I would like to create a pie chart in qlikview to display the total number of "Y" vs the total number of "N". How would i go about doing this?

Thanks

Re: How to create a pie chart in qlikview

Mon, 12 Jan 2015 14:51:15 GMT

Hi,

Go to qlikview objects chart, select pie chart.

Give the dimension field which has your 'Y' and 'N' values. In expression count your dimension field.

HTH

Amay

Re: How to create a pie chart in qlikview

Clever_Anjos — Mon, 12 Jan 2015 15:39:58 GMT

"N" and "Y" are on same field? If yes use the procedure Amay posted, if are different fields, create a pie chart and add two expressions and no dimension

Re: How to create a pie chart in qlikview

Mon, 12 Jan 2015 15:51:31 GMT

1.On the General Page, Select the option 'Pie chart'.

2.Go to the Presentation Page.

3.Mark the check box 'Show Numbers in Legend' (corresponds to 'Number

on Data Points' for bar charts)

4.On the 'Style' page pick a style of your choice for the pie chart.

5.Click 'Ok'. The result is a pie chart where each slice represents the values you provided.

We can use the option to popout.

We can use an conditional expression

Sample Expressions:-

- 1(popout pie chart)

- 0(regular pie chart)

Re: How to create a pie chart in qlikview

Mon, 12 Jan 2015 16:00:18 GMT

For my dimension tab i put Count(complete)... complete is the name of the field. When I click finish i get "No Data to Display"

Re: How to create a pie chart in qlikview

Clever_Anjos — Mon, 12 Jan 2015 16:06:41 GMT

Use only "Complete" as Dimension

Use Count(complete) as expression