Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi chaganti26,
Please post a sample data.
Regards,
Snehal Nabar
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
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;
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.