Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
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))
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))
May be you missed parenthesis
=Count(IF(date_scheduled_fixed>vToday and date_scheduled_fixed<DayStart(Today()+7), date_scheduled_fixed))
Yes. I missed for DayStart(). Thank you.
Thank's alot, the solution Vishwarath gave worked.