Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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. 

 

2 Replies
Highlighted
Specialist
Specialist

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

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.