Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis with Multiple Comparision

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)

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

12 Replies
Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

Can you post sample data here?

Not applicable
Author

Please check attachment for sample Data

Not applicable
Author

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

- Sridhar

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Here you go..!!

Check the attached application.

- Sridhar