topic Calculated value in the main script in QlikView

Calculated value in the main script

Sun, 05 Jun 2011 14:46:33 GMT

Hi Experts,

I'm wonder if it's possible to creat a calculate field in the main script.

My datasource are an excel file.

Example :

LOAD Date,

Libellé,

Débit,

Crédit

FROM

C:\Users...

I aim to do something like this:

LOAD Date,

Libellé,

Débit,

Crédit,

Sum(Credit+Debit) as Total

FROM

C:\Users...

Is it possible ?

Regards,

Pierre.

Calculated value in the main script

nagaiank — Sun, 05 Jun 2011 15:16:27 GMT

Yes. Try the following:

LOAD *, Crédit + Débit as Tot;

LOAD Date,

Libellé,

Débit,

Crédit

FROM

C:\Users...

Calculated value in the main script

Sun, 05 Jun 2011 16:50:10 GMT

It works, thanks.