2 Replies Latest reply: Sep 8, 2016 3:34 AM by nicolas mastronardi

# Calculations between rows of a table - Qlik sense

Hello,

I try to perform calculations between specific rows of a table to display a customized total but I have some difficulty to realize this, can you tell me if I make the right moves / methods for this, it below an explanatory diagram to make it more meaningful!

The formula is: 100 - ((23492 * 100) / 36073)

Should I rather be on the table or directly upstream of the data extraction?

Or is there an other way yet?

Thank you for taking the time to read!

Cordially.

• ###### Re: Calculations between rows of a table - Qlik sense

Would you be able to provide some information about your current dimension/s and expression/s? How many dimensions do you have and what are your expressions?

• ###### Re: Calculations between rows of a table - Qlik sense

Sure i extract the data like that from a txt file :

For all value,

And that is the 3 lines i extrat and use :

(Here its for the value1)

They are in middle of a txt file.

For "intitule" i concatenate 3 column and for the different value i take one column.

I hope ill give you relevant element !