Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adding Calculated row in Straight table

Hi there,

I need to add a calculated row in my straight table based on the values of two different preceding row values.

like, for example,

I have the following table :

Header                           2016

operational cost             30000

operational BL Count      2000

Cost Per BL Count       #####  (calculated row that I need to add : operational cost / operational BL count)

Please Help ASAP.

Thanks.

1 Reply
Anonymous
Not applicable
Author

Could you do that by doing a load on the base header items, then doing a concatenation from a RESIDENT load?