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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)