Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Joseph_Kipling
New Contributor

Re: Count measure is removing the records that don't match set analysis criteria

OK I will create a mock up and send it over.

Re: Count measure is removing the records that don't match set analysis criteria

Can you try this and see if this work

=count({<[Leads.Lead Number]={"=if(([Leads.LeadType]='Retail' and [Leads.LeadCode]=[Leaflet Design]) or ([Leads.LeadType]='Retail' and [Leads.IntervalWeek]<=4 and [Leads.ResponseChannel]='Web') or ([Leads.LeadType]='Retail' and [Leads.ResponseChannel]='Generic'),[Leads.Lead Number])"}>} distinct [Leads.LeadID]&[Leads.First]&[Leads.Last])

+

Sum({1} 0)