Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question to "set analyse"

Hallo,

I need something like this in form of set analyse:

count customer where

( record.startdate >= vStartDate and ( record.enddate is null or record.enddate >= vEndDate ))

Thanks in advance

Heinz

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

count({$ <record.startdate={'>=$(vStartDate)'}, record.enddate={'>=$(vEndDate)'}>} customer)

hope it helps

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

count({$ <record.startdate={'>=$(vStartDate)'}, record.enddate={'>=$(vEndDate)'}>} customer)

hope it helps

Not applicable
Author

Hi Heinz

the syntax is weird but...

count({<record.startdate ={">=$(vStartDate) >=$(vEndDate)">} customer)

best regards

Chris

Not applicable
Author

Hi,

Try this.

Count({<record.startdate = {'>=$(vStartDate) <=$(vEndDate)'}>} customer)