Multiply Table content by Cofficient

[#1]

Good moring,

I ask for your advice because I want to do calculating in a script.

I really don't know how to write relation.

Table [Investissement]     Table [ki]

A                                       k1

B                                       k2

C                                       k3

..                                        ..

..                                        ..

N                                        kn

To obtain Sum (A*k1 + B*k2 + C*k3.... N*kn)

And realised the Sum of all multiply

Do y use loop ? and Incrément ?

Thanks for your reply

Alphonse

[Anonymous]

Alphonse

One thing at time....

Try this in your load script to load your xls and advise if it produces the data table in QlikView you are after ?

Data:

LOAD Annee,

    Investissement,

    Recette,

    Resultat,

    [Valeur du coefficient],

    ( Resultat *  [Valeur du coefficient] ) as [Derived Value] ,

    F6

FROM

Sample_data.xls

(biff, embedded labels, table is Engagement$);

Best Regards,    Bill