Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.

Labels (1)
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?