How to map the data with in a table

rkpatelqlikview — Thu, 10 May 2018 14:59:26 GMT

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,

D2,

D1,

Key2,

Datums,

VehicleNumber ,

[Driver Name]

FROM

(qvd);

topic How to map the data with in a table in QlikView

How to map the data with in a table