Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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)

schema1.PNG

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.

2 Replies
sunny_talwar

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?

Not applicable
Author

Ty for your answer !

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

repQlik.PNG

For all value,

And that is the 3 lines i extrat and use :

(Here its for the value1)

rep2qlik.PNG

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 !