topic Re: Date Expression issue in App Development

Date Expression issue

Nagaraj6 — Fri, 15 Nov 2024 21:49:10 GMT

Hello All,

I need a help

Above is qlikview output: I Need expression In a month of 1st date to yesterday Booking counts is the Backward Booking,

today to end of month is the Forward booking. I am using only Tour_Start_Date with that I have calulate this.

Example Tour_Star_date :

I need expression?

output this form:

Regards

Nag..

Chanty4u — Thu, 11 May 2023 05:38:41 GMT

Try this

Backward Booking Count:

Count({<Tour_Start_Date = {"<=$(=Date(AddMonths(MonthStart(Today()), -1), 'YYYY-MM-DD'))"}>} Tour_Start_Date)

Forward booking count

Count({<Tour_Start_Date = {">$(=Today())"}>} Tour_Start_Date)

Nagaraj6 — Thu, 11 May 2023 06:02:43 GMT

@Chanty4u Thank you!!

I got this below

is this Forword booking end of the month only or next month also will included??

and How to sum of Both expressions?