about excel operations applied in qlikview as script

[#1]

hello guys,

   in excel sheet perform some operations like (leave count)

                           carry forward=annual leaves-leaves taken(balance).

  in excel  i applied formula.

How to write the script in QlikView??

[Anonymous]

hope i understand your question here.

use the same expression in Qlikview as well.

If you are doing this in the load script. it would look like,

LOAD

annual_leave - leaves_taken as carry_forward

From

Etc Etc..

IF you are doing at an expression level in a chart,

add the dimension you want to see the chart at

and in your expression you can just say Sum(annual_leave) - Sum(leaves_taken)

hope this helps.