Hi there, I am very new to Qlik, I have successfully created an App that displays a Pivot Table of information from 2 different tables. I just have the "Companies" associated with each other but I am running into some problems.
In both of my tables I have a column that displays Customer or Non-Customer. I have the two columns labeled differently Table 1 (Customer 1 Column) and Table 2 (Customer 2 Column). Sometimes in table 1 it will say that the company is a customer, sometimes it will say it in table 2. Sometimes both tables say it and sometimes one table says it is a customer and the other table does't.
I want to be able to show in my pivot table all customers or non-customers but it only takes information from one table or the other. I tried to create an IF function to combine the columns but it is not working correctly.
I am very new and have very little to no knowledge on scripts and code. If someone could help I would much appreciate it!
Both tables have different and same data. So for instance, I want to consolidate all the emails associated with the companies. In table 1 I have some emails and in table 2 I have the same, different or no emails.
Table 1 (Email Column) | Table 2 (Email Column) | Data I want to Show