Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Mapping or join

Hi All,

I have two tables.

In one table i have A,B,C,D.....K

In second table i have A,B,C,D,L.

Now i need to use combination of A,b,C,D(from 1st table if i don't use A,B,C,D from second table also fine) to get the value for L which is in second table.

Now for this what i need to do join or link the tables or Mapping.. I am not sure.

Can you please help me on this.

Thanks,

Bharat

32 Replies
bharatkishore
Creator III
Creator III
Author

Bec that no data is coming in category list box.. so i don't want it to there.

if i give this condition then ApplyMap('Final_Category',Key) then in category listbox i am getting many fields..


But thanks a lot for your time..

kakani87
Specialist
Specialist

As you said 'NoData' is not displayed in Asif's final document if so .. in case of yours

you can use in list box expression as

=if(match(Category,'T&M','Warranty','Contract Covered'), Category)

bharatkishore
Creator III
Creator III
Author

ohh my bad.. thank you.....