topic Re: Calculated Fields in QlikView

Calculated Fields

Anonymous — Fri, 06 Mar 2015 08:27:47 GMT

I am creating a table where some of the fields I want are dependant on previously calulated fields, is there an easy way to do this

For example if I have calculated field as follows,

Load

* as ,

then if I want field to be * how can I do this without having to script * *

Thanks

Re: Calculated Fields

MK_QSL — Fri, 06 Mar 2015 08:32:34 GMT

Provide some sample data with your sample apps... will look into this..

Re: Calculated Fields

tresB — Fri, 06 Mar 2015 08:40:50 GMT

Try preceding load like,

Load

* as ; // preceding load

Load

* as

From <>;

Re: Calculated Fields

puttemans — Fri, 06 Mar 2015 08:42:19 GMT

Hi Adrian,

If you want to calculate it in the same table, and you don't want to re-script the formula, then a preceding load may help you.

This looks like

Table X

LOAD

c*d as Y;

LOAD

a*b as C

FROM .....

Notice the ';' after the first load statement

Re: Calculated Fields

jagan — Fri, 06 Mar 2015 09:00:59 GMT

Hi,

Try Preceding Load for this

TableName:

LOAD

* AS E;

Load

* as ,

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Calculated Fields

robert_mika — Fri, 06 Mar 2015 09:08:01 GMT

Try this:

t1:

load * Inline

[

A,B,D

1,2,3 ]

;

t2:

load

A*B as c

resident t1

;

temp:

load c as C resident t2;

join

load D resident t1;

;

final:

load C*D as E resident temp;

drop table t1,t2,temp

Re: Calculated Fields

Anonymous — Fri, 06 Mar 2015 14:40:00 GMT

I've tried your method but it's not quite working. I have a table which has a record for each sale and I'm trying to achieve a calculation of the distribution costs for each sale. So if my original tabel has 50 records, I should get a new table with 50 records, however I am getting 50 records for each sale. This is the script and qvw attached

'CalcTest':

Load ((Pallets - DirectPallets) * DistributionCost) + (DirectPallets * DirectDistributionCost) as TotDistribution;

Load
Year,
Week,
Product,
Units,
Pallets,
Pallets * DirectPallet% as DirectPallets,
DistributionCost,
DirectDistributionCost
resident 'Sheet1';

drop field DistributionCost,
DirectDistributionCost,
DirectPallet%;

Re: Calculated Fields

puttemans — Fri, 06 Mar 2015 14:46:02 GMT

Hi Adrian,

If you want the other variables still to be visible, please add a '*,'

Load *,

((Pallets - DirectPallets) * DistributionCost) + (DirectPallets * DirectDistributionCost) as TotDistribution;

Re: Calculated Fields

mukesh24 — Fri, 06 Mar 2015 14:48:47 GMT

Hi,

U can achieve these through Preceding Load.

Regards,

Mukesh Chaudhari