Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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))))

Labels (1)
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)