topic Re: expression: using a time span in QlikView

expression: using a time span

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

=Count(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7))

dont look at that as actual qlik code, but what would be the correct syntax for something like this.

I just want to show the number of dates between today and 7 days from now.

vishsaggi — Thu, 05 Jul 2018 20:41:49 GMT

May be this?

=Count(IF(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7, date_scheduled_fixed))

missed a parenthesis

=Count(IF(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7), date_scheduled_fixed))

Anil_Babu_Samineni — Fri, 06 Jul 2018 02:00:18 GMT

May be you missed parenthesis

=Count(IF(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7), date_scheduled_fixed))

vishsaggi — Fri, 06 Jul 2018 04:36:44 GMT

Yes. I missed for DayStart(). Thank you.

Anonymous — Fri, 06 Jul 2018 13:24:34 GMT

Thank's alot, the solution Vishwarath gave worked.