Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

expression is right ?

(Sum (if("Date d'entrée") < ('31/01')  and GetFieldSelections(year))

and

(Sum ( if ([Date de sortie]) => ('01/01') and GetFieldSelections(year))))

1 Reply
jwjackso
Specialist III
Specialist III

If these are date fields,

=Sum({<[Date d'entrée]={"<$(=MakeDate(GetFieldSelections(year),01,31))"},[Date de sortie]={">=$(=MakeDate(GetFieldSelections(year),01,31))"}>} SomeAmt)