topic Re: Calculation a value from future value QLIKSENSE in QlikView

Calculation a value from future value QLIKSENSE

s_santalucia — Wed, 24 Jan 2018 10:15:22 GMT

Hi All,

is it possibile to calculate a value from future value?

I have attached the excel file as an example.

Thanks.

Re: Calculation a value from future value QLIKSENSE

Ralf_Heukäufer — Wed, 24 Jan 2018 10:51:46 GMT

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.

Re: Calculation a value from future value QLIKSENSE

s_santalucia — Wed, 24 Jan 2018 11:03:03 GMT

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!

Re: Calculation a value from future value QLIKSENSE

s_santalucia — Wed, 24 Jan 2018 11:55:04 GMT

UP,

please!

Re: Calculation a value from future value QLIKSENSE

Ralf_Heukäufer — Wed, 24 Jan 2018 12:25:54 GMT

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

Re: Calculation a value from future value QLIKSENSE

s_santalucia — Wed, 24 Jan 2018 13:12:26 GMT

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.

Re: Calculation a value from future value QLIKSENSE

Ralf_Heukäufer — Wed, 24 Jan 2018 13:30:55 GMT

To transponse a Table in the Script use crosstable:

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

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

Re: Calculation a value from future value QLIKSENSE

s_santalucia — Wed, 24 Jan 2018 13:38:38 GMT

No,,

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

Re: Calculation a value from future value QLIKSENSE

Ralf_Heukäufer — Wed, 24 Jan 2018 13:46:54 GMT

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

How they are calculated?

Re: Calculation a value from future value QLIKSENSE

s_santalucia — Wed, 24 Jan 2018 13:51:33 GMT

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

Re: Calculation a value from future value QLIKSENSE

Ralf_Heukäufer — Wed, 24 Jan 2018 14:18:18 GMT

If the table looks like your example Data and you transponse it you can work above and below in your table visualisation:

Above - chart function ‒ Qlik Sense

Below - chart function ‒ Qlik Sense

above("MEASURE A") / (below("MEASURE C")+below("MEASURE D"))

Re: Calculation a value from future value QLIKSENSE

s_santalucia — Wed, 24 Jan 2018 14:24:18 GMT

ok, thanks.

I try to do it.

Re: Calculation a value from future value QLIKSENSE

petter — Wed, 24 Jan 2018 15:09:50 GMT

If you do a CROSSTABLE LOAD in the load script you can use a Pivot Table and the measure can be calculated with Before() and After() chart functions along with a calculated dimension to get the two rows Result A and Result B:

I have attached the Qlik Sense application which this screenshot was taken from...

Re: Calculation a value from future value QLIKSENSE

s_santalucia — Wed, 24 Jan 2018 15:18:19 GMT

Thank you.

I will try to do it.

Re: Calculation a value from future value QLIKSENSE

petter — Wed, 24 Jan 2018 15:20:10 GMT

If you consider your question answered please mark the solution with correct to close this thread

Re: Calculation a value from future value QLIKSENSE

s_santalucia — Thu, 25 Jan 2018 13:36:04 GMT

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.