Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

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

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

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
Valued Contributor III

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

HI clinton,

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



Thanks,

Arvind Patil

Community Browser