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: 
Anonymous
Not applicable

Set Analyis Combination

Hi,

I am trying to summarise data by a field called StatChoice.

StatChoice
Email
Phone
Yes
No

This field contains varied answers which I need to combine, for example count the number of Cases which have an 'Email' flag


The expression works when in a textbox when I use:


=(Count(Distinct{$<StatChoice={'Email'}>}Case)


However, I want to summarise this further by counting the number of cases with an 'Email' flag and a response of 'Yes'


Any suggestions on how this can be achieved?


Thanks,

Paul



1 Reply
sunny_talwar

May be this

=Count(DISTINCT {$<StatChoice={'Email'}, Response = {'Yes'}>}Case)