Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arusanah
Contributor

help with expression

count(if({<[Population Group Code]={2},[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"},[MonthYear]=,[Year]= ,[BGMonth]=

>} DISTINCT[Person ID],0))

I need count of (Person ID) if above conditions is true else zero . somehow I am not able to put it thru . pls help

3 Replies
MVP
MVP

Re: help with expression

May be this:

RangeSum(

Count({<[Population Group Code] = {2}, [Date] = {">$(varMinSelectedDate)<=$(varSelectedDate)"}, [MonthYear] =, [Year] = , [BGMonth] =>} DISTINCT [Person ID])

Avg({1}0))

arusanah
Contributor

Re: help with expression

not working

briancopple
Contributor II

Re: help with expression

Have you tried replacing the variables in the set analysis with the actual dates hard coded just to see if that makes a difference?