Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mariia_gridneva
New Contributor II

Question: count only those respondent who pick different answer alternatives but still grouped by question

Qlik Sense

There is no problem in displaying and counting respondents who answered on alternatives from question1 AND question2.

Issue comes when we want to see respondents from more than one alternative per question.

With logic: count respondents who answered similarly on ((Q1_a OR Q1_b) AND Q2_a)

Here comes data model.

DataModel.PNG

In the following example I choice two respondents in alternative Q2_a (resp 101 and 102 displays).

Q2_a.PNG

When looking on one of alternatives in Q1, (Q1_a) the result count only one respondent (101) existing in both choice-alternatives.

Q1_a_AND_Q2_a.PNG

The same goes for combination of (Q1_b) where respondent (102) exists along with (Q2_a).

Q1_b_AND_Q2_a.PNG

Adding alternative (Q1_a) which contains (101) respondent to the choice should give two respondents in calculation. One respondent coming from Q1_a and Q1_b each and two of same existing in Q2_a.

Result displays zero respondents.

Q1_a_OR_Q1_b_AND_Q2_a.PNG

Logic I need is counting/showing respondents existing in Q1 AND Q2, plus alternatives Q1_a OR Q1_b compared against Q2.

I can also accept changes in the data model.

Sorry for the long post.

Best regards, Mariia.

Community Browser