topic calculated field in table box in QlikView

calculated field in table box

Mon, 10 May 2010 16:19:51 GMT

Hi, I am using a table box and I want to add a calculated filed, Is there any way to do this, with out using chart ?

Thanks in Advance

calculated field in table box

Mon, 10 May 2010 16:26:28 GMT

Not in a table box as far as I am aware, but why not do this in a straight table?

calculated field in table box

spsrk_84 — Tue, 11 May 2010 11:11:23 GMT

Hi,

We can't add a calculated Field to the Table Box,but you can do the same in Straight table or Pivot table...

another thing is like u can create a field in the script part itself and use that field for Analysis ,i feel that will survive ur purposes.........

Regards,

Ajay

calculated field in table box

Tue, 11 May 2010 22:58:49 GMT

I am having the same problem, and was approaching it from the scripts angle. But I can't figure out how the script should be written. Any pointers?

Thank you,

Ian

calculated field in table box

Tue, 11 May 2010 23:11:19 GMT

I think I've figured it out, but not sure if it's the right approach.

In the script, I added another row under a table with the two data fields that I wanted to multiply

[Qty Received]*[USD Price]

This created a new box in the fields view. I right clicked on the title of the box, and selected Properties and gave it a Title

"Received Value"

Although this title took in the fields view, when I went to the Table view, the field was still named '[Qty Received]*[USD Price]'

Is there anyway I can name the new field within the new line in the script? I tried using '=[Receipt Value]' both before and after the calculation, but I get an error on the Reload.

Any ideas?

Thank you,

Ian

calculated field in table box

Tue, 11 May 2010 23:17:35 GMT

The syntax for renaming a field (or calculation) in the load script uses the "as" keyword

[Qty Received]*[USD Price] as "Received Value"

Hope this helps,
Andy

calculated field in table box

Wed, 12 May 2010 01:48:53 GMT

Thank you all.

That last syntax from andy was spot on.