Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
jreimerink
Contributor
Contributor

Set analysis help with less than

Hi All,

I'm struggling with the row below.

This shows all emails created today, but i want it to show before today.

I tried to add < but it only give back 0. Can somebody help me with this?

Thanks!

Count( {1<[Contact_Created.autoCalendar.Date] = { "$(=Date(Today(), 'D-M-YYYY'))" },Contact_Group={"TNL"},Contact_Channel={"Email"}>} [Contact_Created.autoCalendar.Date])

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi @jreimerink 

Try like below

Count( {1<[Contact_Created.autoCalendar.Date] = { "<$(=Date(Today(), 'D-M-YYYY'))" },Contact_Group={"TNL"},Contact_Channel={"Email"}>} [Contact_Created.autoCalendar.Date])

 

if its not working, please send the sample file

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi @jreimerink 

Try like below

Count( {1<[Contact_Created.autoCalendar.Date] = { "<$(=Date(Today(), 'D-M-YYYY'))" },Contact_Group={"TNL"},Contact_Channel={"Email"}>} [Contact_Created.autoCalendar.Date])

 

if its not working, please send the sample file

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
jreimerink
Contributor
Contributor
Author

Thanks, this works!