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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Set analysis issue

I am using the below expression but quantity is coming 0.

if([Table Source]='WHUIL200',Sum({$<("Invoice_Date_GMT")={'$(vLastmonthdate)'}>} Quantity))

 

Basically, my date field ("Invoice_Date_GMT") should match my variable vLastmonthdate.

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I don't think the () around the "Invoice_Date_GMT" are valid.

-Rob