Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pthomas3253
New Contributor II

Count with a date filter applied

I'm trying to do the below formula with a date filter of 12/01/2017. Any assistance appreciated.

count([2])*2+count([3])*3+count([4])*4+count([5])*5+count([6])*6+count([7])*7+count([8])*8+count([9])*9+count([10])*10)/(Count([Employee_ID])

3 Replies
Digvijay_Singh
Honored Contributor III

Re: Count with a date filter applied

What exactly you need help for? Can you share dimension, measures, sample data, expected output to respond appropriately.

dwforest
Valued Contributor

Re: Count with a date filter applied

The same set expression would need to be added to each count():

count({$<date={"12/01/2017")>} [2])

Note your date format setting would need to be "mm/dd/yyyy" and there can be no time in data. If there is, it gets a little more complex:

target_date = date#("12/01/2017");

count({$<IDField={"=floor(date)=$(target_date)"}>} [2])

nizamsha
Valued Contributor

Re: Count with a date filter applied

I am not sure what u r asking but i am giving an eg in what i understand

Load * Inline [

ID,Name,Amount

1,A,100

1,A,100

2,B,200

2,B,200

2,B,200

2,B,200

2,B,200

3,c,300

4,d,400

5,e,500

6,f,600

];

Measure1:=Count( ID)

Measure2:==Count(ID)* Sum(Aggr(Count(ID),ID))

Community Browser