Insert variable values in a excel table

Tue, 26 Aug 2014 08:39:53 GMT

Hello everybody,

how can i manipulate an Excel List. I have a original table with data inside. I saved formulas as variable. My Goal ist to save the solution of the formulas in a new Excel list (calculated table)

Original table

figures	€
Revenue I	1
Revenue II	2
Cost I	4
Cost II	5

Here you see my formulas in the LOAD:

Sum ([Revenue I + II]) = sum(if(figure='Revenue I') + sum(if(figure='Revenue II')

Sum([Cost I + II]) = sum(if(figure='Cost I') + sum(if(figure='Cost II')

Div([Cost/Revenue]) = $(Sum([Revenue I + II])/$(Sum([Cost I + II])

Calculated table

figures	€
Revenue I	1
Revenue II	2
Sum(Revenue I+II)	3
Cost I	4
Cost II	5
Sum(Cost I +II)	9
Div([Cost/Revenue])	3

I hope someone understand my Problem and know how to solve this Problem.

Thanks.

topic Insert variable values in a excel table in QlikView

Insert variable values in a excel table