Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
"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
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)
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"
Use only "Complete" as Dimension
Use Count(complete) as expression