Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Classic Search
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
- Qlik Community
- :
- All Forums
- :
- Search
Search
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
1,531 results
Sorted by:
2016-01-06
07:01 PM
... YearMonth Sales Volume Exponential Forecast (0.1) Exponential Forecast (0.7) Oct-2014 90 Nov-2014 106 Dec-2014 152 Jan-2015 244 F...
- Tags:
- new_to_qlikview
2011-04-12
03:31 AM
Hi All, How do i add weather forecast into my qlikview application? Please suggest. Thanks !
Show results in replies (9)
-
Here is something I did just as an experiment - have never used it for anything. I'm pretty sure I ...
-
i got it thanks! 🙂 also, where and how can we get google api? for instance for maps ? are goog...
-
Yes it is very simple. As you have said - just take the load script from the 'Weather' tab. As I m...
-
Thank you so much Nathan, this was a great help. However I am new to Qlikview can you pleae elabora...
-
It runs on a variable (vCity) which you can change - see the input box below the weather data. If y...
-
can i use it as the exact code from weather tab in the edit script?
-
oh this is so cool!! how do i use it in my application? i want it for my country and city. i.e Cou...
-
hey, this is not what i require although idea is the same. my company made a customized dashboard b...
-
Hi I have wonderful example from Rakesh. Please find the attached file hope that helps Regards ...
2015-07-21
07:03 AM
...ales forecast For example: Sale of item A from 01/01/2015 to today is 25420 Today is day 202 of the year Sales for each day are 25420/202 = 125,8415842 31/07/2015 will be the 212 day of the year I...
- Tags:
- new_to_qlikview
Show results in replies (6)
-
Hi, I have created the forecast data till year end for each item. I have slightly modified your e...Forecast.qvw (166 KB)
-
Thank you, your answer is helpful. But what I need is to calculate the forecast until the end o...
-
Please see the attached with some changes
-
Something like in attached?
-
Hi, thanks for the reply Forecast data will be provided by Business (data come from a database s...
-
thanks but your solution stops with today date and I need to make the forecast until the end of year
2018-12-15
05:00 AM
Dear all I have problem in writing script to forecast the sales volume, please help urgently. The correct answer is computed and shown in the worksheet. Thank you Tracy
Labels
- Subscribe by Topic:
-
General Question
2016-08-06
03:04 AM
Hi every one , I have a excel like below, i want a bar chart that show sale amount for exist year and show forecast sales for 2016(next year) , which function i can do ? please help me ? B...
2019-07-24
04:03 AM
...4/2019,A,25 7/24/2019,B,25 7/24/2019,C,25 7/24/2019,D,25 7/24/2019,E,25 7/24/2019,F,25 ]; Now I know how many parts is there on stock up until today, but now my task is to implement a "Forecast...
2016-07-12
05:01 PM
All, I have a simple bar chart with 4 years of data, and I want to add an additional 5 years of forecasting data. Any advice. This is just dummy data for a demo, so as long as I can show something t...
2016-04-03
04:35 PM
Hi all, I ask me a question... I have a data ; point of sales and churn by week and I want to know how many point of sales are going to terminate the activity in 6 months ? Is it possible to ob...
2011-04-18
10:04 AM
Hi everyone, Could you give me a hint how to make a forecast of stock level? I have ItemId, StockLevel, AvgOutcome I need to make a +14 days forecast - on daily basis Example: item stock a...
Show results in replies (7)
-
If you always want 14 columns to the right then just hard code them: Stock + avg_outcome Stock + ...
-
OK - don't think I understood your requirements completely, but glad you found a solution.
-
Thanks, Nathan Wonderful idea. I use (Date-Today()) as N counter for (Stock + Avg_Outcome * N) Ch...
-
Yep, just cumulative variance between stock and avg outcome by days to see when the product will be...
-
and you just want 14 columns to the right showing the declining stock levels over 14 days?
-
Hi Nathan, Thanks for quick reply. (Qty1 / 14) is AvgOutcome for 14 days before today. KR, Mich...
-
Which one of your columns in your attached example represents the "avg_outcome" column that you men...
2015-06-17
07:34 AM
Hi, I like to show an forecast. (simulation) Here an example of my problem. name, Date, value TYP A, Nov15, 99 I have many of these types but I like to reduce the value each month of -1 H...