Discussion Board for collaboration on QlikView Scripting.
I have a table like
A B C D E
1 2 3 sales Profit
2 3 4 Commisions Loss
6 8 9 Margin Profit
Now I have to load based on coumns D and E using resedent load.
If D= sales and e= Profit then A-B as xxxx
else if D=Commission and E = Loss as YYY etc
Go to Solution.
Try liek this
If (D= 'Sales' and E= 'Profit', A - B,
If(D='Commissions' and E = 'Loss', somecalculation)) AS XXXX
In the script.
Load your normal data from your sheet.
If (D= 'Sales' and E= 'Profit', A - B, If(D='Commissions' and E = 'Loss', somecalculation)) AS New Field
Try like this
If (wildmatch(D,'Sales') and wildmatch(E,'Profit'), A - B,
If(wildmatch(D,'Commissions') and if(E,'Loss'), calculation)) AS NewField
Jagan has given you the way to do so ,
May this in detail will make you clear
,If (D= 'Sales' and E= 'Profit', A - B,
drop table Table1;
Now you can use one more resident load from table 2 if you want to exclude on basis of field XXXXX.