Hello Qlik Community,
i have a big matter. Hopefully, you can help me. I would like to calculate a RunRate (prognose) for the current month. RunRate is a future prognose for the current month based on past data of current month. I would like to explain my matter with three tables.
First, I upload a calendar table similar to this calendar. The calendar contains all the date information.
Second, I upload a sales table similar to this table. The sales table doesn't contains all the date information.
1. If a date is not in Sales Table, then for RunRate Amount = 0.
2. The Average of Sales Amount between First date of month (10/1/2016) and Today(10/5/2016) = 10.
3. I would like to have in the new Table in RunRate Amount for IF(Workday = 1, then Average 10, IF(Workday = 0, Then =0.
4. Until End of Current Month.
johanlindell maybe, you know what i mean. Thx again