topic Re: How to create calculated column in script? in QlikView

How to create calculated column in script?

Tue, 16 Apr 2013 05:10:48 GMT

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

Re: How to create calculated column in script?

Tue, 16 Apr 2013 05:40:51 GMT

Hi chaganti26,

Please post a sample data.

Regards,

Snehal Nabar

Re: How to create calculated column in script?

peschu123 — Tue, 16 Apr 2013 08:15:15 GMT

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

Re: How to create calculated column in script?

er_mohit — Tue, 16 Apr 2013 09:52:13 GMT

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;

Re: How to create calculated column in script?

Tue, 23 Jun 2015 08:40:41 GMT

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.