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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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