Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rkpatelqlikview
Creator III
Creator III

Mapping to one field with condition with in the table

Hi Experts,

Hope you are doing great.

Please find the attached QVW.

In this QVW i have done some level mappings in the Main tab and taking that Tab Qvd in to Main4.

I need to show the final DriverName from All these maps are to be done.

In Main4 tab, We have D1, D2,D3 and one more column  [Driver Name]. Here i need generate one final DriverNAme following this condition. consider the D1 first, If D1 there is a nulls then i should consider D2, If D2 get nulls  then D3 and then  [Driver Name],

I'm in trouble to find the FinalDriverNAme. Please let me know for more clarification.

1 Solution

Accepted Solutions
el_aprendiz111
Specialist
Specialist

Hi,

=if(len(trim(D1))=0 or if(len(trim(D2))=0,D3,D1),D3,D1)

View solution in original post

6 Replies
bhaskar_sm
Partner
Partner

HI,

Can you clarify this "get nulls  then D3 and then  [Driver Name]," ??

Regards,

Bhasker

rkpatelqlikview
Creator III
Creator III
Author

Hi Bhaskar,

Thanks for your respond. This was i did with Nested ApplyMaps but there is a one more challenging. In this final Applymap i have given DriverName even if not found in final level the it should show that

VehicleNumber & UnknownDriver. how to overcome this.

ApplyMap('Temp1', Do_Number, 

      ApplyMap('Temp2', Key2,

            ApplyMap('Temp3', VehicleNumber, [Driver Name]))) as D3,

Temp1:

Mapping Load Do_Number,  DriverNames Resident TripReport;

Temp2:

Mapping LOAD Key2, DriverNames Resident TripReport;

Temp3:

Mapping LOAD  VehicleNumber,DriverName3 Resident DriverMaster;

transafekm3:

LOAD

  ApplyMap('Temp1', Do_Number, 

      ApplyMap('Temp2', Key2,

            ApplyMap('Temp3', VehicleNumber, [Driver Name])))  as D3,

    Key2,

     Datums,

     Plant,

     [Carrier Code],

     [Carrier Name],

     [Vehicle Catagory],

     VehicleNumber,

     Do_Number,

    [Driver Name]

------]

allisonbaldan
Contributor II
Contributor II

Hi Kumar,

Your attachment doen'st have these ApplyMap that you provied in your answers, is there other .qvw more updated?

Either way, I have attached my solution, see if this helps you.

rkpatelqlikview
Creator III
Creator III
Author

Yes. That's correct. If i gets the null in DriverName. It should show  "VehicleNumber & Unknown Driver"

rkpatelqlikview
Creator III
Creator III
Author

Excellent Allison, Thanks for your great help.

Now i did this one with applymap. I'm attaching the Qvw. If the DriverNames data will get nulls at that it should show

  " VehicleNumber&Unknown ". I don't know how can we map this with in a table field.

and i need to fetch the some data from Both the table. Like DriverID,Plant1 from toptable and Driver Id and LicenceId from DriverMaster.

Used with Left Join. Is this right way to get the related data?

el_aprendiz111
Specialist
Specialist

Hi,

=if(len(trim(D1))=0 or if(len(trim(D2))=0,D3,D1),D3,D1)

View solution in original post