Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)