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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

set analysis error

I'm trying to use this expression to find previous year sale .

=Sum({$<TimeLine.Year={$(=(TimeLine.Year)-1)}>}(Fact.CustomerSales*[CurrencyConversion.USD - Budgeted Rate CFY]))

when i execute this expression it displays zero . where as i do have sales for that year . i'm defn missing something in this expression ... but im not able to figure out .

pls help

Labels (1)
1 Reply
maxgro
MVP
MVP


=Sum({$<TimeLine.Year={$(=max(TimeLine.Year)-1)}>}(Fact.CustomerSales*[CurrencyConversion.USD - Budgeted Rate CFY]))