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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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