topic Re: How to generate one new column across three stages in QlikView

How to generate one new column across three stages

rkpatelqlikview — Wed, 09 May 2018 09:50:25 GMT

Hi,

Please find the attached sample data. Please suggest on this.

There are 3 stages. from that stages i need to generate one new column that FinalPerson as shown in excel.

Thanks for your support.

Re: How to generate one new column across three stages

YoussefBelloum — Wed, 09 May 2018 10:07:07 GMT

Hi,

this is one way to do it

PFA

Re: How to generate one new column across three stages

rkpatelqlikview — Wed, 09 May 2018 10:26:35 GMT

Thansk for your great help Youssef.

Re: How to generate one new column across three stages

rkpatelqlikview — Wed, 09 May 2018 10:57:56 GMT

Thanks for your great help Youssef.

Re: How to generate one new column across three stages

rkpatelqlikview — Thu, 10 May 2018 14:20:21 GMT

Hi Youssef,

The same scenario but 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 nits still empty it shioud give

Vehicle Number.

Can i get this with same script, I used it in my back end?

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);