Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
giosultan
Contributor
Contributor

Define Time Series and Calculate Delta, depending on choice

Dear All,

I am quite at a beginner level , therefore I am struggling with several tasks at the time. My challenge at the moment is to create or define two or three time periods e.g Previous Year ,Actuals, Budget, Forecast and depending on the choice calculate delta. Act vs Budget, act vs FC etc.

I have to be able to choose Region, country, Business Unit...
My questions.

should I Create a table and bundle different time series under one Collumn "Time" or table with 4 collums with values for above mentioned time series?

How do I calculate delta?

any support would be greatly appreciated

0 Replies