topic Re: Qlikview Expression in QlikView

Qlikview Expression

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Qlikview Expression

ahaahaaha — Wed, 07 Jun 2017 08:13:36 GMT

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

Re: Qlikview Expression

micheledenardi — Wed, 07 Jun 2017 08:14:57 GMT

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" ?

Re: Qlikview Expression

Anonymous — Wed, 07 Jun 2017 09:06:31 GMT

You mean Creating Variables?

Re: Qlikview Expression

vardhancse — Wed, 07 Jun 2017 09:22:52 GMT

Ley vVariableName = expression;

Re: Qlikview Expression

Wed, 07 Jun 2017 14:43:20 GMT

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?

Re: Qlikview Expression

ger_alegria — Wed, 07 Jun 2017 15:16:29 GMT

To create a new column through expresion try whit:

Load

Expresion as New_Field

From....

i.e:

Load

A+B as MyField

From....

Re: Qlikview Expression

tajmohamed30 — Wed, 07 Jun 2017 18:55:45 GMT

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

Re: Qlikview Expression

Anonymous — Wed, 07 Jun 2017 19:10:58 GMT

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.

Re: Qlikview Expression

tajmohamed30 — Wed, 07 Jun 2017 19:21:14 GMT

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

Re: Qlikview Expression

Anonymous — Wed, 07 Jun 2017 19:23:13 GMT

Thanks for the explanation taj, but I was responding directly to the original poster.

Re: Qlikview Expression

tajmohamed30 — Wed, 07 Jun 2017 19:29:48 GMT

anyhow if he understood then well and good

Re: Qlikview Expression

Anonymous — Wed, 07 Jun 2017 19:35:28 GMT

True.