topic Re: PIE CHART in QlikView

PIE CHART

manoranjan_d — Tue, 13 Oct 2015 18:10:37 GMT

Hi all,

Below is the data.

SID	QID	Question category	answer	score
S1	1	AA	agree	5
S1	2	BB	disagree	6
S1	3	CC	moderate	7
S1	4	DD	neutral	8
S2	1	AA	disagree	5
S2	2	BB	agree	6
S2	3	CC	moderate	7
S2	4	DD	neutral	8
S3	1	AA	Neutral	5
S3	2	BB	disagree	6
S3	3	CC	agree	7
S3	4	DD	neutral	8

I want to display the pie chart as per the below details example:

Details

I want it for particular question category, not for all question category

Example:

question Category AA has agree, disagree, neutral moderate, in this i want to know the count( SID).

please help which thing has to be used in dimension and expression.

Re: PIE CHART

Anonymous — Tue, 13 Oct 2015 18:15:56 GMT

How far have you got so far ?

And what is your current stumbling block ?

Re: PIE CHART

manoranjan_d — Tue, 13 Oct 2015 18:18:57 GMT

I cant get the data for particular question category, when i use question category as dimension it showing for all question category , so i need to view the data only for particular question category

Example question category AA

has agree, disagree, neutral moderate and in that i want to know the count( SID)

Re: PIE CHART

Clever_Anjos — Tue, 13 Oct 2015 18:22:37 GMT

use count({<[Question category]={"AA"}>} SID). as expression and answer as dimension

Re: PIE CHART

Digvijay_Singh — Tue, 13 Oct 2015 18:27:21 GMT

I don't understand that when you want to count SID based on question category then how does it matter the value of Answer which you are explaining in your requirements, not sure if I have valid doubt.

Re: PIE CHART

ogster1974 — Tue, 13 Oct 2015 18:35:23 GMT

‌create a filter object on Question category to Swtich between your questions then create a pie object with answer as dimension and count(distinct SID) as your measure.

REgards

Andy

Re: PIE CHART

manoranjan_d — Tue, 13 Oct 2015 18:40:42 GMT

use count({<[Question category]={"AA"}>} SID). as expression and answer as dimension

got answer based on the above stmt

Re: PIE CHART

manoranjan_d — Tue, 13 Oct 2015 18:42:29 GMT

how to create filter object on Question category

Re: PIE CHART

Clever_Anjos — Tue, 13 Oct 2015 18:50:07 GMT

Add a Listbox to your application and choose Question Category

I recommend you this series of videos www.youtube.com/watch?v=ifO7pF5CLBM

Re: PIE CHART

ogster1974 — Tue, 13 Oct 2015 18:50:28 GMT

‌Go to add new object and select a list box and select question category as your dimension you want to display. Then you can remove your set analysis from your count measure and let the list box filter determine the question category selected by the user.

REgards

Andy

Re: PIE CHART

manoranjan_d — Tue, 13 Oct 2015 18:53:56 GMT

i need seperate pie chart for each quesion catergory

Re: PIE CHART

Clever_Anjos — Tue, 13 Oct 2015 18:59:22 GMT

So use 4 (or more objects) and change the Set Analysis string accordingly

Re: PIE CHART

manoranjan_d — Tue, 13 Oct 2015 19:03:28 GMT

thanks clever