Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
HomerJ99
Contributor
Contributor

Simple Expression Syntax

May not be possible but I simply want to return results from two tables (both text fields) rather than having to create a separate query for each table. For example, suppose I have two customer lists: one called customer.name with customer names, email, etc.; the other called customer.companyname which has all the similar data. What expression would be useful to get a listing of both of these name fields? The other fields (email, phone, etc.) are named the same; only the name field is different.

Labels (1)
2 Replies
sidhiq91
Specialist
Specialist

@HomerJ99  I am not able to understand the requirement completely. Could you please provide some sample data or some kind of data structure that would help me to help you out. 

HomerJ99
Contributor
Contributor
Author

I have a table of customer names, addresses, phones, etc. I have a 2nd table of company names, addresses, phones, etc. I can create a table/pivot table to bring in all the table information for each set separately, but I am looking for an expression to bring in both sets together. Linke some sort of AND function.