Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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!