Hi Qlik,
Can any one help on this please.
D1 is having Level2,D2 is having Level3,D3 is having Level4. then I should take this data in to one field after if any empty cells it should take the data from DriverName after that there is a another level even if its still empty it should give
Vehicle Number.
Can i get this with same script, I used it in my back end?
Below i tried its not working.
LOAD
if(len(trim(D1))<>0 and (len(trim(D2))=0 or Len(trim(D2))='Level3') and (len(trim(D3 ))=0 or len(trim(D3 ))='Level4'), D1,
if((len(trim(D1))=0 or len(trim(D1))= 'Level2') and len(trim(D2))<>0 and (len(trim(D3 ))=0 or len(trim(D3 ))='Level4'), D2,
if((len(trim(D1))=0 or len(trim(D1))= 'Level2') and (len(trim(D2))=0 or Len(trim(D2))='Level3') and len(trim(D3 ))<>0, D3
))) as Driver,
D3
D2,
D1,
Key2,
Datums,
VehicleNumber ,
[Driver Name]
FROM
(qvd);