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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Manuel174102
Creator
Creator

How to project the rest of the days of the year in a line chart

Hello Everyone.

 

I have a graph that is showing sales per year in the last 5 years. The sales dropped in 2022, clearly, because the year in not over. I would like to project the rest of the years in the graph. How could I do that? is there any function?

What I mean is, lets say that I sold 10 euros from the 01.01.2022 to today. 263 has passed since 01.01.2022, so at the end of the year I would have (102/365)*10=2,8... so I would have 12,8 euros at the end of the year.

 

Greetings

Labels (1)
0 Replies