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

Set analysis to bring through data from today + the next 14 days

Can some one help me with the correct expression that will provide episode level detail on records from today + the next 14days.

=Count({<SessionDate={">$(=Today()+14)"}>}ID)

3 Replies
Kushal_Chawda

=Count({<SessionDate={">=$(=today())<=$(=Today()+14)"}>}ID)

sunny_talwar

You might need to add Date functions here (especially for Today() + 14 part as this will be converted to a number as soon as your add 14

=Count({<SessionDate={">=$(=Date(Today(), 'DateFieldFormatHere'))<=$(=Date(Today()+14, 'DateFieldFormatHere'))"}>}ID)

arvind_patil
Partner - Specialist III
Partner - Specialist III

HI clinton,

I Think,both the expressions are correct use according to r need.



Thanks,

Arvind Patil