Discussion Board for collaboration on QlikView Scripting.
is it possibile to calculate a value from future value?
I have attached the excel file as an example.
Solved! Go to Solution.
I found the solution at my question.
I posted it here:
it is necessary to delate the "where condition' in [As-Of Calendar]: :
<<<<<Where AsOfMonth >= Month>>>>>;
for my understanding.
Have you future values and you would calculate with them?
Or would you calculate future values based on your data?
In the first case, yes this is possible.
For the second case you can use advanced analytics with a R Server and create forecast calculations.
I have the value future .
I wanto to calculate a value at specific month that depend on the value future.
for gen 2017, I need to take the value of march 2017(that I have it!).
Did you see the excel file?
To transponse a Table in the Script use crosstable:
there are many articles about table transponse in the community too.