topic Re: Simple Expression Syntax in QlikView

Simple Expression Syntax

HomerJ99 — Tue, 09 Aug 2022 15:40:37 GMT

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.

Re: Simple Expression Syntax

sidhiq91 — Wed, 10 Aug 2022 03:42:31 GMT

@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.

Re: Simple Expression Syntax

HomerJ99 — Mon, 15 Aug 2022 09:48:11 GMT

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.