Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jaymeknapp
Contributor III
Contributor III

Qlik Sense Set Expression w/ Variable

Greetings!

 

I'm trying to create an expression that will give me sales (for the previous month PM) for a specific location (St.Cloud).   This expression does not seem to be working for me??..??

=SUM({$<[Location Name]={'St.Cloud'}>}(=$(vTotalSales(PM))))

What am I missing?

 

Labels (2)
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

What is the definition of 

vTotalSales

-Rob

jaymeknapp
Contributor III
Contributor III
Author

vTotalSales =

Sum({$<[%dateflag_$1]={1},
[Transaction Line Accounts Account Number]={404120,404110,404100,404118,404119},
[Transaction Type]={'Invoice','Cash Sale','Cash Refund','Credit Memo', 'Bill', 'Journal'}, $(vExcludeDateFields)>} [Transaction Line Gross Amount])