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]

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

like

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

[s_santalucia]

ok, thanks.

I try to do it.

[petter]

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...

[s_santalucia]

Thank you.

I will try to do it.

[petter]

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

[s_santalucia · Accepted solution]

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.