Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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