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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
oliviawang
Contributor
Contributor

question about expression

I'd like to add a baseline.  When the year is 2020, the full year budget is A, when the year is 2021 it's B.

My data is like this :

year  month  fy_budget

2020    1            20

2020    2            20

  ...

2020   12           20

2021    1            70

2021    2            70

...

2021    12           70

pic.png

 

 

 

How can I write the expression? 

I use: aggr(aggr(avg(fy_budget),year),month),  but it can't work.

 

 

0 Replies