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

AND statement help

Hey I would like to something like, sum TransactionAmount thats between start and end dates, ( i would like to get the sum of transactions in a selected month )

if anyone could please point me in the right direction.

SUM( {< Year=, PeriodName=, postingDate={"<=$(vEndDate)" AND ">=$(vStartDate)"} >}  TransactionAmount)

thanks.

Bon.

10 Replies
Anonymous
Not applicable
Author

I still haven't fixed this. I think all solutions provided is correct but currently im using the incorrectly data field. so I'll look further into which field is related.