Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
is it possibile to calculate a value from future value?
I have attached the excel file as an example.
Thanks.
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"))
ok, thanks.
I try to do it.
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...
Thank you.
I will try to do it.
If you consider your question answered please mark the solution with correct to close this thread
Hi all,
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>>>>>;
Thanks all.