topic Re: Monthstart Function in a set analysis in QlikView

Monthstart Function in a set analysis

Anonymous — Fri, 05 Jul 2013 08:50:09 GMT

Hello,

I'm trying to use this syntax in my set analysis, but a i have always a return of 0.

=Sum ({1 < ORDERED_DATE = {">= $(=Monthstart(vMaxDate))" } > } ORDERED_AMOUNT_CHF)

ORDERED_DATE is a date and vMaxDate a Date variable.

Wath's wrong?

Thanks

Re: Monthstart Function in a set analysis

alexandros17 — Fri, 05 Jul 2013 08:52:21 GMT

Are you sure that both date have the same format?

Re: Monthstart Function in a set analysis

Fri, 05 Jul 2013 08:53:58 GMT

=Sum ({$ < ORDERED_DATE = {">= $(=Monthstart(date(vMaxDate)))" } > } ORDERED_AMOUNT_CHF)

Re: Monthstart Function in a set analysis

rajni_batra — Fri, 05 Jul 2013 10:01:18 GMT

store

(=Monthstart(vMaxDate))" in a variable and check is the date format same for both the dates you r comparing in ur expression & then apply it or u can use new created variable also.

Re: Monthstart Function in a set analysis

Anonymous — Fri, 05 Jul 2013 10:11:15 GMT

Always a result of 0.

Re: Monthstart Function in a set analysis

Anonymous — Fri, 05 Jul 2013 10:12:34 GMT

You right we use a date format 'YYYY-MM-DD' for the ORDERED_DATE and the same for vMaxDate.

With this formula for only the vMaxDate

=Sum ({1< ORDERED_DATE={"$(=vMaxDate)"}>}ORDERED_AMOUNT_CHF)

I have the total amount for this day. In this case the date format is valid at the both side.

I have also try some date formating of the monthstart but without any success.

Re: Monthstart Function in a set analysis

alexandros17 — Fri, 05 Jul 2013 10:30:11 GMT

Hi Jelpache,

I've simulated the problem and my expression

sum({$ <datestart={'>=$(=monthstart(vOggi))'}>} 1) (equal to yours) works. what you must check is if one of the dates (probably

ORDERED_DATE) is date-time, in this case convert it to date and try again