Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
jaymeknapp
Contributor II
Contributor II

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

What is the definition of 

vTotalSales

-Rob

jaymeknapp
Contributor II
Contributor II
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])