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

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

Prior Year missing Revenues

All, I have 5 products with revenue last year, and this year only for of them have revenue. When comparing this years revenue vs last years revenue, I am receiving the proper grand total, however the product shows up but the revenue is blank?... any ideas?

({$< Year= {$(= GetFieldSelections(Year)-1)},[Calc.Type] -= {'Forecast*'},Date={"<=$(=vMaxDate)"}>}[Amount])/Factor

help.jpg

Labels (1)
0 Replies