topic Re: Set Analysis with Multiple Comparision in QlikView

Set Analysis with Multiple Comparision

Tue, 24 May 2011 05:26:39 GMT

Dear All,

How can we show the below two expressions in a Pie Chart so that it shows customer count for
Questions Q1,Q2,Q3,Q4,Q5,Q6 with specified condition.

Dimension is Question_No.

Expressions:

Count({<Survey_Type={'Service'}, Question_No = {'Q3','Q5','Q6'},AnswerID = {'2'} >}Customer)

count({<Survey_Type={'Service'}, Question_No = {'Q1','Q2','Q4'},AnswerID = {'<9'} >} Customer)

Set Analysis with Multiple Comparision

Tue, 24 May 2011 05:31:42 GMT

Kumar,

Did you tried inserting '+' between these two exprerssion?

Count({<Survey_Type={'Service'}, Question_No = {'Q3','Q5','Q6'},AnswerID = {'2'} >}Customer)

count({<Survey_Type={'Service'}, Question_No = {'Q1','Q2','Q4'},AnswerID = {'<9'} >} Customer)

Check this.

- Sridhar

Set Analysis with Multiple Comparision

Tue, 24 May 2011 05:38:39 GMT

Yes I have tried with + also but the issue is only first expression is getting considered in Chart i.e. Q1,Q2,Q4 getting display.
Second expression is not getting reflect.

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 05:39:03 GMT

Yes I have tried with + also but the issue is only first expression is getting considered in Chart i.e. Q1,Q2,Q4 getting display.
Second expression is not getting reflect.

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 05:41:03 GMT

Can you post sample data here?

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 05:49:26 GMT

Please check attachment for sample Data

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 05:55:26 GMT

Check the attached application. I have created my own data.

- Sridhar

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 06:06:13 GMT

I am unable to get the same with my sample excel attached

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 06:06:38 GMT

I am unable to get the same with my sample excel attached.

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 06:09:48 GMT

Here you go..!!

Check the attached application.

- Sridhar

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 06:19:26 GMT

Thanks Sridhar, data not getting satisfied for second exp. thats the reason.

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 06:47:53 GMT

Could you explain me what data is not getting satisfied, so that i could help you out.

condition for second part of the expression is below.

count({<Survey_Type={"Service"}, Question_No = {'Q1','Q2','Q4'},AnswerID = {"<9"} >} Customer)

as per the condition, only satisifying row are 3.

Service	Q1	Were all requested jobs done first time?	6	6	Rajesh
Service	Q2	Was service completed within promised delivery time?	8	8	Rajesh
Service	Q4	Was your vehicle delivered clean?	1	1	Rajesh

can explain me what is the problem.?

- Sridhar

Re: Set Analysis with Multiple Comparision

Tue, 24 May 2011 07:03:48 GMT

Dear Sridhar,

Thanks for your reply.

Our Sol. was correct, 2nd exp was not getting considered bcz there was not data which could satisfy 2nd exp.

Thanks,