Can we access the value of column which is calculated by using some expression for further expression.?

[#1]

Hii All,

Can we access the value of column which is calculated by using some expression for further expression.

like I have table:

FieldA          FieldB                            FieldC          FieldD          FieldE       

A                    01-01-2013                   a                    i               a+i-100

B                    01-01-2013                   b                    j               b+j+200

C                    01-01-2013                   c                    k              c+k-50

D                    01-01-2013                   d                    l               d+l+140

A                    02-01-2013                   e                   m              e+m+(a+i-100)

B                    02-01-2013                   f                    n               f+n+(b+j+200)

C                    02-01-2013                   g                   o               g+o+(c+k-50)

D                    02-01-2013                   h                   p               h+p+(d+l+140)

i.e. for 1-jan-2013 i have to use a constant value for calculation but if the same value fieldA comes with next date then the fieldE will use the value of its previous calculated value in the same expression.

How can we do it?..

Please help.

Thanks and Regards.

[jagan]

Hi,

You can reuse the expressions in chart by using Column(n) or by giving the expression name directly.

Example:

1) Sum(Sales) - Assume caption(Label) is Product Sales

2) Sum(Tax) - Assume caption (Label) is Sales Tax

3) Total = [Product Sales] + [Sales Tax]

OR

Total = Column(1) + Column(2)

Hope this helps you.

Regards,

Jagan.

[#3]

Hii Jagan,

Thanks for Reply,

But the problem is this that i have to use the Calculated Expression of previous value into the current value..

That means the Expression used for these calculations is same.

[jagan]

Hi,

Try Above(), check Help file for examples.  Can you attach a sample file.

Regards,

Jagan.

[#5]

Yes Jagan,

My File is Attached but in this you can Go through last sheet in which i am working.

Where i need to calculate Projected Stock on Hand using InitialStock

which is given Initially but after that my ProjectedStockonHand will become my InitialStock for next date.

Thanks and Regards.

[#6]

Hii Jagan,

Above() method cannot be used in this case as i donot know whether the next value comes just below it of after some other products so i need to use some condition related to FieldA.

[qliksus]

Hi,

Try to use column(1) as below,

FieldA          FieldB                            FieldC          FieldD          FieldE       

A                    01-01-2013                   a                    i               a+i-100

B                    01-01-2013                   b                    j               b+j+200

C                    01-01-2013                   c                    k              c+k-50

D                    01-01-2013                   d                    l               d+l+140

A                    02-01-2013                   e                   m               e+m+Column(1)

B                    02-01-2013                   f                    n               f+n+Column(2)

C                    02-01-2013                   g                   o               g+o+Column(3)

D                    02-01-2013                   h                   p               h+p+Column(4)

Thanks,

Susant