topic Re: create 2 calculated fields in the cloud from this table. in QlikView

create 2 calculated fields in the cloud from this table.

Sat, 02 May 2015 22:14:47 GMT

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.

Re: create 2 calculated fields in the cloud from this table.

petter — Sat, 02 May 2015 23:14:31 GMT

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.

Re: create 2 calculated fields in the cloud from this table.

Mon, 04 May 2015 16:23:23 GMT

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.

Re: create 2 calculated fields in the cloud from this table.

petter — Mon, 04 May 2015 16:38:29 GMT

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