How to create calculated column in script?

[#1]

    Hi Team,

How to created one field (cloumn) in script,

by using the column again i want to create calucalted column,

but if i creating calculted column by using field iam getting field not found?

thanks

[#2]

Hi chaganti26,

Please post a sample data.

Regards,

Snehal Nabar

[peschu123]

Hi Chaganti,

your description could be a bit more detailed. But I assume the problem you are running into, can be solved by "preceding load". An example can be found on this website.

Or just look in google for "qlikview preceding load".

Regards

Peter

[er_mohit]

using residentand Group by functions you can do it

like this

test1:

LOAD  * INLINE [

    A, B

    1, 1

    2, 2

    3, 3

    4, 4

    5, 5

    6, 5

];

test_1:

LOAD A*B as AB,

min(A) as AAB

Resident test1

Group by A,B;

[#5]

Hi Chaganti,

It's very simple:

Try like this:

Table:

Employee ID, EmpSal, [Emp Special Allowances]

1, 100, 200

2, 200, 100

3, 100,150

Take Chart like Straight or any Bar Chart

Step 1: Load Data

Step 2 : Select New Sheet Object -> Chart -> Bar Chart

Step 3: Choose Dimension -> Add Calculated Dimension -> Write like:- Empsal + [Emp Special Allowances]  as Net Salary

Step 4:  Expression as EmpId

Step 5: Finish

You can get best  solutions.

Ramya.