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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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

0 Replies