Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bbmmouha
Creator
Creator

problem with date

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

3 Replies
MK_QSL
MVP
MVP

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

Hope mois_a is date field

bbmmouha
Creator
Creator
Author

it 's always zero 0

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

sunny_talwar

Then add date format to your expression

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