topic Re: Calculate expression on previously calculated row in the same expression in QlikView

Calculate expression on previously calculated row in the same expression

Wed, 10 Sep 2014 04:22:25 GMT

Hi,

I have met with a new requirement, which I need to get the input value from an input box, calculate the value of first row, then take the first row value as input to the second row calculation in expression, and third row need to calculated based on the value generated in second row and so on....

Need to calculate Jan sales value on user input, Jan Sales value is input for Feb Sales value, Feb value to Mar Sales value.

I have an input box, which getting data from users. Eg: if user input is 10%, then calculate Jan sales value to 90% of the actual sales.

Need to take the value generated for Jan Sales as the input and calculate the Sales value for Feb.

Feb Sales value as input to the Mar Sales Value calculation.

and so on... up to December Sales.

Can you people, please suggest me, how to achieve this in Qlikview.

Regards,

Nuthan Kumar

Re: Calculate expression on previously calculated row in the same expression

sushil353 — Wed, 10 Sep 2014 04:36:16 GMT

Hi Nuthan,

You can easily do this using above function.

Say you are getting inputbox data into variable vInputbox

Then you can write your expression something like:

=Sum(Sales)*alt(Above(Sum(Sales)),$(vInputbox))

HTH

Sushil

Re: Calculate expression on previously calculated row in the same expression

Wed, 10 Sep 2014 05:32:44 GMT

Hi,

Use Above function in expression of chart

Above function is used to get the previous value in chart