Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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)