Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

prsparrow2017
New 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



Tags (2)
1 Reply

Re: Set Analyis Combination

May be this

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

Community Browser