Hello again...OK...let me try with another example....a real one that I was hoping to do with an IF....or in the LOAD....(sorry for the bad examples before)...
Let's say I have 3 fields, a key (TheKey), A Supplier ID (Supplier) and Line Number (LineNo)....
What I would like to do is, if the Supplier is = to "" (blank but not null), then I want to take the Supplier from LineNo = 1 WHERE for the same key. One key = 1 line on the invoice, so there can be 10 lines, 9 blank (or maybe less but always there will be one on line number 1)
I tried as an IF and in the LOAD but always come up with a syntax error that doesn't really reflect the problem (it will appear later in the script and have nothing to do with anything I did).
I can do that....in the mean time, mayhbe this will help. What I really want to learn how to do, if I can do it, is make in QlikView, basically an SQL Subselect statement. So, very simply (the dataset is hundreds of thousands of rows):
LOAD *, TheKey, Supplier,
RowNo,, if(RowNo = 1, Supplier, (SELECT Supplier WHERE RowNo=1) AS Supplier2, //Sort of how I would do it in SQL ;