This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have two tables as shown below.
Load * inline [
I want to derive new column percentage with COMM and SAL.
Required column: COMM/SAL.
How to achieve this?
Thanks in advance.
Use mapping load in your script
Load * inline [EMPNO,A,B,SALEMPNO1,A1,B1,10EMPNO2,A2,B2,20EMPNO3,A3,B3,30EMPNO4,A4,B4,40EMPNO5,A5,B5,50];Mapping_Table:Mapping Load EMPNO,SAL Resident TableA;TableB:load *, COMM/ApplyMap('Mapping_Table',EMPNO) as Percentage;Load * inline [EMPNO,COMM,CEMPNO1,10,C1EMPNO2,20,C2EMPNO3,30,C3EMPNO4,40,C4EMPNO5,50,C5];
View solution in original post
load *, COMM/SAL as percentage
drop table TableA;
I would do the calculation in the UI and do:
How would you do? Please help to provide code.
The JOIN has been done as I indicated in the Load Script I posted.
The calculation in a chart would simply be:
COMM/SAL as an expression where you need it to be calculated ....
Thank you All.