topic Re: Add a calculated column in QlikView

Add a calculated column

Tue, 04 Mar 2014 11:34:54 GMT

I need to add a calculated column i.e. I have 4 columns in my existing data, once this data is uploaded in Qlikview I need to add a calculated column (calculation will be based on 2 existing columns) which will be my 5th column in my dataset. This new column will be used in different char/graphs. How can I achieve this?

Re: Add a calculated column

tresB — Tue, 04 Mar 2014 11:38:40 GMT

To be able to use the same calculated field in different charts, calculate it in the script like:

Load

FieldA,

FieldB,

FieldA*100+FieldB AS calculatedField

from <>;

Re: Add a calculated column

Tue, 04 Mar 2014 11:38:49 GMT

Hi,

When you load your table you can add fields as you like.

For example, if you are loading the following table:

Load A,

FROM File;

You are able to do something like this:

Load A,

A + B as C,

A - B as D

FROM File;

Regards.

Re: Add a calculated column

nilesh_gangurde — Tue, 04 Mar 2014 11:39:20 GMT

What type of calculations you need to perform. ??

-Nilesh

Re: Add a calculated column

Anonymous — Tue, 04 Mar 2014 11:40:00 GMT

Hi Abhinav,

1.You can create column by creating a field(Result of Calculated two columns) in load script.

and select the create field in chart.

2.Create a expression in Expression tab of a chart

Re: Add a calculated column

Tue, 04 Mar 2014 11:49:11 GMT

Thank guys but is there a possibility of doing the same without using script? I mean, using some option in Qlikview after loading the data.

Re: Add a calculated column

Tue, 04 Mar 2014 11:53:20 GMT

Yes using expressions as Nitha says, in my example you can do a expression as sum(A) + sum(B) or sum(A + B) depending of you want.

Re: Add a calculated column

Tue, 04 Mar 2014 11:57:15 GMT

try:

Table2:

LOAD

IDKey,

sum(data1) as Data1Sum,

sum(data2) as Data2Sum

Resident Table1;

LEFT JOIN (Table2)

LOAD

IDKey,

Data1Sum-Data2Sum as DifferenceSum

Resident Table2;

Is this what you are looking for?

Thanks,

Angad