Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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