If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am struggeling with a problem for a few month now. There are several posts that are kind of similuar but there is still something missing.
I have the current Stock value for the current month(e.g. june) in table stock.
I would like to create a calender or table for the next 36 month, the value for every month should be the current sum(stock value) like e.g.
Monthname(date); sum(stock value)
So on for next 36 month
In a Chart i would do this with total but i would like to create this in load Statement to create a canonical calender to join several calender dates like Orders to create a forecast.
This is just a part of my hole problem but find a solution for this part would help me a lot.
Thanks for every hint and sorry for this really bad discription of my situation.
Thanks for Replying. As feared my question was not clear but i guess I solved it by my own. I try on monday to implement it. The solution should look like this.
While IterNo() <= 36;
I Know there are a lot of syntax errors but the concept should work.
This was a really bad first question to join the community but thanks anyway.
View solution in original post
Monthname(date); sum(total stock value)