Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Table B
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.
Please try using join keyword instead of concatenate
@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.