topic Re: How to implement this functionality based on previous row calculations? in QlikView

How to implement this functionality based on previous row calculations?

Wed, 12 Apr 2017 10:17:28 GMT

Hello Dears

I have the following functionality to implement in Qlikview. Can you please help?

As I don't know how to retrieve the value calculated from one row and bring in into another column into the next row to calculate a new value?

Please find attached excelsheet for reference. THanks in advance.

Re: How to implement this functionality based on previous row calculations?

Anil_Babu_Samineni — Wed, 12 Apr 2017 10:21:20 GMT

Use like below for [Projected Stock]

Below(Sum([Stock Quantity]))

More information, Look at here Missing Manual - Above() and Below()

Re: How to implement this functionality based on previous row calculations?

Wed, 12 Apr 2017 10:27:23 GMT

Hello Anil,

Thanks for your response. In my excel sheet, the data has been ordered by Year and Week.

But this may not be the case in the real raw data files.

Can the function 'Below(Sum([Stock Quantity]))' still be used in this case?

Best Regards,

Chandu

Re: How to implement this functionality based on previous row calculations?

Anil_Babu_Samineni — Wed, 12 Apr 2017 10:32:14 GMT

Thanks for your response. In my excel sheet, the data has been ordered by Year and Week.

You can use Sort option in Qlikview

But this may not be the case in the real raw data files.

What does the Mean real raw data. Would you share sample data with 5 rows and let us know expected result

Can the function 'Below(Sum([Stock Quantity]))' still be used in this case?

May be we can go a head if you reply for second one

Re: How to implement this functionality based on previous row calculations?

Wed, 12 Apr 2017 10:44:04 GMT

Hello,

I meant that in the true raw data each row has approximately 50 to 60 different column names such as company, Item Name, Country, model code, model name and data for 3 years that is around 150 weeks of data for millions of items.

Would it be difficult to order it using sort?

Or maybe is it possible to use joins in order to implement the above functionality?

Re: How to implement this functionality based on previous row calculations?

Wed, 12 Apr 2017 11:31:59 GMT

The functionality I require would be to implement the above in qlik scripting so that I have the above data in the form of a table. Can you please help?

Thanks in advance

Re: How to implement this functionality based on previous row calculations?

spividori — Wed, 12 Apr 2017 12:24:33 GMT

Hi.

Check the attachment. Hope this help!. !

Re: How to implement this functionality based on previous row calculations?

Thu, 13 Apr 2017 06:59:34 GMT

Thanks lots Dear Sandro, it looks good I'll implement it in my dashboard and let you know how it goes