topic Use 'and' and 'or' in SET analysis on the same dimension in QlikView

Use 'and' and 'or' in SET analysis on the same dimension

Thu, 18 Feb 2016 12:30:35 GMT

HI there. Can anyone help a newbie a little?

I want to sum all "Answer" (1 or 0) that has answered either '2_q10N1_1' or '2_q10N1_2' AND that has answered '2_q9b10N3_4' or '2_q9b10N3_5' for Answer_ID.

=sum({<Answer_ID={'2_q10N1_1','2_q10N1_2'} * {'2_q9b10N3_4','2_q9b10N3_5'} >}Answer)

Is there a way to do this?

Thank you

Re: Use 'and' and 'or' in SET analysis on the same dimension

Gysbert_Wassenaar — Thu, 18 Feb 2016 18:07:00 GMT

Maybe like this:

=sum({<Answer_ID={'2_q10N1_1','2_q10N1_2'}, Respondent_ID=P({<Answer_ID={'2_q9b10N3_4','2_q9b10N3_5'} >}Respondent_ID)>}Answer)

Re: Use 'and' and 'or' in SET analysis on the same dimension

Fri, 19 Feb 2016 07:41:45 GMT

Thank you Gysbert