how to combine and show 2 columns from different table as 1 list box

[qliklearnervir]

Hi ,

I have 1 requirement where i have 2 different table with column department from 2 different table .

Table 1                                                 Table 2

Department                              Department  

A                                                             B

B                                                           C

C                                                          E

                                                              F

i have measure column as profit .

now first i have to merge and show this column as 1 list box and another thing need to do as when ever i select any value from department 1 which are not present in department 2 should not impact profit value for table 2.

similarly for table 2 department.

Like i selected department E , which is not in Table 1 , so table 1 data should not change and only profit for table 2 should change .

please suggest the possible scenario. 

[vamsee]

Qlik by default will either implicitly concatenate both the tables if both of them have same fields or will create an association based on Department. Resulting in one Department field on the front end.

Coming to Req 2, if you want both the Profits to be combined for the Departments present in both the tables I would suggest you to concatenate both the tables. Like

Final:
Load 
Department,
Profit
From [Table 1]
;
Concantenate(Final)
Load 
Department,
Profit
From [Table 2]
;

In the front end, lets say you create a chart with Department as dimension and expression Sum(Profit), it would only show Profit from Table 2 for Department E

[Brett_Bleess]

If Vamsee's post got you what you needed, we would greatly appreciate it if you could close out the thread by using the Accept as Solution button on his post.  This will give him credit for the assistance, and it also lets other Community Members know this worked.  If you are still needing further assistance, please leave an update comment on the thread.

The other place you can search for further ideas would be the Design Blog area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett