Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BTproj
Contributor
Contributor

After contcatenation - filter field from a table to populate values of different table in qliksense

Hello People

I am using contatenation in qliksense to join different tables. I need to know on how to write a set analysis query to filter field from one table to get values of different table.

I have created sample file for explanation. For example - I have two tables : A and B.

Table A

q12.PNG

Table B

q13.PNG

Both tables are concatenated in qliksense using 'cus_id'. I need to add 'nid' as a filter to get data of product and revenue. When i filter any particular 'nid', values for  product and revenue are not getting populated. How can i solve this issue.

 

I have also attached a sample qvf file. Thanks in advance.

 

Labels (1)
2 Replies
anushree1
Specialist II
Specialist II

Please try using join keyword instead of concatenate

BTproj
Contributor
Contributor
Author

@anushree1 Thanks for your reply..I have built the model by joining different tables using concatenation, so i want to know on how to use fields from other table as filter.