Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
jaymeknapp
New Contributor

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
MVP & Luminary
MVP & Luminary

Re: Qlik Sense Set Expression w/ Variable

What is the definition of 

vTotalSales

-Rob

jaymeknapp
New Contributor

Re: Qlik Sense Set Expression w/ Variable

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])