Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

s_santalucia
Not applicable

Calculation a value from future value QLIKSENSE

Hi All,

is it possibile to calculate a value from future value?

I have attached the excel file as an example.

Thanks.

1 Solution

Accepted Solutions
s_santalucia
Not applicable

Re: Calculation a value from future value QLIKSENSE

Hi all,

I found the solution at my question.

I posted it here:

The As-Of Table

it is necessary to delate the "where condition' in [As-Of Calendar]: :

<<<<<Where AsOfMonth >= Month>>>>>;



Thanks all.



15 Replies
Ralf_Heukäufer
Not applicable

Re: Calculation a value from future value QLIKSENSE

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
Not applicable

Re: Calculation a value from future value QLIKSENSE

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
Not applicable

Re: Calculation a value from future value QLIKSENSE

UP,

please!

Ralf_Heukäufer
Not applicable

Re: Calculation a value from future value QLIKSENSE

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
Not applicable

Re: Calculation a value from future value QLIKSENSE

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
Not applicable

Re: Calculation a value from future value QLIKSENSE

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
Not applicable

Re: Calculation a value from future value QLIKSENSE

No,,

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

Ralf_Heukäufer
Not applicable

Re: Calculation a value from future value QLIKSENSE

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

How they are calculated?

s_santalucia
Not applicable

Re: Calculation a value from future value QLIKSENSE

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