create 2 calculated fields in the cloud from this table.

[#1]

hello, my name is Daniel, I have some questions about a calculated field in QlikView.

I have an .xls file that has the following information:

company year month and value

And I need to create 2 calculated fields in the cloud from this table.

Here's how the table should be on a dynamic object.

company	year	month	value	value2(calculated)	value3(calculated)
dtt	2000	Jan	10	=before value(Year&Month)	=before value(Year&Month) - actual value
dtt	2000	Feb	20	= 10	= 10 - 20
dtt	2000	Mar	10	= 20	= 20 - 10
dtt	2000	Apr	20	= 10	= 10 - 20
dtt	2000	May	30	= 20	= 20 - 30
dtt	2000	Jun	40	= 30	= 30 - 40
dtt	2000	Jul	0	...	...
dtt	2000	Ago	10	...	...
dtt	2000	Sep	23	...	...
dtt	2000	Oct	34	...	...
dtt	2000	Nov	5	...	...
dtt	2000	Dec	12	...	...

I will be grateful in support of this issue.

Thank you.

[petter]

You can create a Chart - Straight Table like this and create three expressions like you see below - I have also attached the demo QlikView Application so you can inspect the solution yourself:

The Above()-function is the one that serves your purpose in this case.

The last three column headers have a copy of the expressions for the columns in them. As is the default if you don't override it.

[#3]

Thank you for your answer. But in my situation, "above" should come from extraction.

In this case, if any month selection in the table object, the expression will not work.

[petter]

That can be achieved like this - also see the updated attachment with the updated load script:

!