Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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