topic problem with date in QlikView

problem with date

bbmmouha — Fri, 13 Apr 2018 11:01:01 GMT

hello

i want to add an indicateur whith date

i try this

=sum({<mois_a = MonthStart(Today())>} AMOUNT#LOCAL#1)

i want to the sum of amount between the star of month and actual date

thank you

MK_QSL — Fri, 13 Apr 2018 11:03:38 GMT

=sum({<mois_a = {">=$(=MonthStart(Today()))<=$(=Today())"}>} AMOUNT#LOCAL#1)

Hope mois_a is date field

bbmmouha — Fri, 13 Apr 2018 11:10:44 GMT

it 's always zero 0

this didn't work my be because date form is YYYYMMDD

sunny_talwar — Fri, 13 Apr 2018 11:18:45 GMT

Then add date format to your expression

=Sum({<mois_a = {">=$(=Date(MonthStart(Today()), 'YYYYMMDD'))<=$(=Date(Today(), 'YYYYMMDD'))"}>} AMOUNT#LOCAL#1)