Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted

May be this

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