Qlikview Expression

[#1]

Can anybody tell me how to create or store temporarily a value for each record to be later used in an expression in Qlikview ? Also want to know how to add a column through expression in Qlikview?

[ahaahaaha]

Hi,

1) "to create or store temporarily a value for each record" - all depends on the tasks being solved, but in any case it will be either a table or a variable

2) "how to add a column through expression" -

LOAD

....,

Expression or Value your new Field as [Name New Field]

FROM....

Regards,

Andrey

[micheledenardi]

Hi Akash,

to store a value for each record you have to work in load statement:

For example if you want to create a new field "Value":

Invoice:

Load

    Number,

    Qty,

    Price,

    Qty*price    as Value

from Invoice.qvd (qvd);

What do you mean "add column through expression" ?

[Anonymous]

Hi

You mean Creating Variables?

[vardhancse]

Ley vVariableName = expression;

[#6]

The question is how to create or store temporarily a value for each record to be later used in an expression in qlikview I need this not in the loading script but during calculation?

[ger_alegria]

To create a new column through expresion try whit:

Load

     A,

     B,

     Expresion as New_Field

From....

i.e:

Load

     A,

     B,

     A+B as MyField

From....

[tajmohamed30]

Hi Reddy,

You can use variables to store your expression and can be used at any object in qlikview.

For adding column in pivot or straight table you can go to the expression tab in the properties option by right cliking the chart..

Also find useful informations for newbie.

http://community.qlik.com/thread/31007

http://community.qlik.com/docs/DOC-1794

http://community.qlik.com/qlikviews/1000

http://community.qlik.com/docs/DOC-1986

Hope it helps, you can mark answered if you like this information

Regards

Taj Mohamed

[Anonymous]

Based on your explanation........

If you're creating a Straight Table chart, you could have an expression/column with value you want to temporarily store.

Then in another expression, you can refer to that first expression by column name.

If you don't want the column with the temporarily stored value to be seen you can just hide it on the Presentation tab.

[tajmohamed30]

In simple terms let us assume, variables=memory card(in mobiles)

                 functions(expressions/calculations)=songs, videos etc

Now you can use use memory card to store songs or videos and that stored memory card can be used at any devices.

Similarly you can use Variables to store functions and can be used anywhere in any charts.

Regards

Taj Mohamed