topic Re: How to create a pie chart based on alpha numeric values ? in QlikView

How to create a pie chart based on alpha numeric values ?

Tue, 23 Jun 2015 11:01:54 GMT

i am sharing the source data column and expected pie chart, any idea how to create it ?

thanks.

Re: How to create a pie chart based on alpha numeric values ?

MK_QSL — Tue, 23 Jun 2015 11:05:33 GMT

Dimension

YourFIeldName

Expression

Count(YourFieldName)/Count(Total YourFieldName)

Re: How to create a pie chart based on alpha numeric values ?

hariprasadqv — Tue, 23 Jun 2015 11:08:11 GMT

Hi,

Devide the data into two coulmns and use as source so that you get Right one.

Re: How to create a pie chart based on alpha numeric values ?

sunny_talwar — Tue, 23 Jun 2015 11:09:46 GMT

You can use a dual function in your script which will assign satisfaction with a numeric as well as alpha-numeric value.

So something like this:

Pick(Match(Satisfaction, 'Very satisfied', 'Satisfied', 'Neutral', 'Dissatisfied', 'Very dissatisfied'), Dual(Satisfaction, 5), Dual(Satisfaction, 4), Dual(Satisfaction, 3), Dual(Satisfaction, 2), Dual(Satisfaction, 1)) as SatisfactionDual

Re: How to create a pie chart based on alpha numeric values ?

Tue, 23 Jun 2015 11:20:34 GMT

Hi @MRKachhiaIMP,

i think it worked, but i didnt get it exactly, can you please elaborate the expression a little ?

Re: How to create a pie chart based on alpha numeric values ?

Tue, 23 Jun 2015 11:22:26 GMT

and how to calculate and display the percentage

Re: How to create a pie chart based on alpha numeric values ?

hariprasadqv — Tue, 23 Jun 2015 11:25:31 GMT

Use Relative property in Expression.

Re: How to create a pie chart based on alpha numeric values ?

Tue, 23 Jun 2015 11:28:25 GMT

nope, its not working

Re: How to create a pie chart based on alpha numeric values ?

hariprasadqv — Tue, 23 Jun 2015 11:29:15 GMT

Your data consisting of 3 diffrent values. Consider them as dimension values.

Assue Total number of values as 20.

In that 6 as 5.Very satisfied -> (6/20)*100

In that 6 as 4.Satisfied -> (6/20)*100

In that 8 as 5.Neutral -> (8/20)*100

Re: How to create a pie chart based on alpha numeric values ?

MK_QSL — Tue, 23 Jun 2015 11:30:05 GMT

I thought you want to know how many times

1.Very Dissatisfied

2. Dissatisfied etc is coming...

Considering that your field name is [Overall satisfaction of facilities and services] you can get the desired result by

COUNT([Overall satisfaction of facilities and services])/COUNT(TOTAL [Overall satisfaction of facilities and services])

Go to Number tab and select Fixed To 2 Decimal and Tick Show in Percent (%)

COUNT(FieldName) will give you count of individual values (i.e. how many times 1.Very Dissatisfied is appearing and so on)

COUNT(Total FieldName) will give you total values for this fieldname

Re: How to create a pie chart based on alpha numeric values ?

Tue, 23 Jun 2015 11:35:59 GMT

ohh, got it.

i did what you said for the % but still its not working.

Re: How to create a pie chart based on alpha numeric values ?

MK_QSL — Tue, 23 Jun 2015 11:36:36 GMT

Provide sample data please !

Re: How to create a pie chart based on alpha numeric values ?

Tue, 23 Jun 2015 11:38:51 GMT

PFA

Re: How to create a pie chart based on alpha numeric values ?

Tue, 23 Jun 2015 12:35:39 GMT

any idea how to divide that column into two ?

Re: How to create a pie chart based on alpha numeric values ?

MK_QSL — Tue, 23 Jun 2015 12:43:15 GMT

CHECK enclosed file...

Re: How to create a pie chart based on alpha numeric values ?

Tue, 23 Jun 2015 12:59:14 GMT

Perfect !! Thanks a lot Manish.

so it isnt necessary to separate the column into two columns ?