Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

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
sunny_talwar

May be this:

RangeSum(

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

Avg({1}0))

arusanah
Creator II
Creator II
Author

not working

Anonymous
Not applicable

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