Calculation a value from future value QLIKSENSE

[s_santalucia]

Hi All,

is it possibile to calculate a value from future value?

I have attached the excel file as an example.

Thanks.

[Ralf_Heukäufer]

Hello Stefania,

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.

[s_santalucia]

Hi,

I have the value future .

I wanto to calculate a value at specific month that depend on the value future.

for Example:

for gen 2017, I need to take the value of march 2017(that I have it!).

Did you see the excel file?

thank you! 

[s_santalucia]

UP,

please!

[Ralf_Heukäufer]

To read it i have change your Excel file

I have transponded the data

After that you can work with it.

I upload my qvf file here

[s_santalucia]

Hi,

it is not that I need.

I need to do the same thing on scripts, I can not upload the exel file because it's just an example.

[Ralf_Heukäufer]

To transponse a Table in the Script use crosstable:

http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptPrefixes/cross...

there are many articles about table transponse in the community too.

[s_santalucia]

No,,

because the fields "RESULT A" and "RESULT B" I have to calculate!!!!!!!!

[Ralf_Heukäufer]

And this calculation doesn't work after a transponse any more?

How they are calculated?

[s_santalucia]

if you click in the cell with the values of result a, you see.  for this reason the excel file in an example.