Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tenyeapen
Contributor
Contributor

2 columns from 2 query

I have a customer name field in 2 different queries. how can I combine that and create a list box so that all the graphs using both queries should work.

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

You need to Model within qlik appropriatly. there are multiple approaches hard to recomment one without knowing more about your data.some options are

when loading the data make sure the customer name columns in both tables as the same

or model in such a way that you combine the 2 queries into a single table

or model in such a way that customer names are a single dimension table. 

 

Share a sample of your 2 query results. and how you are loading it in the script

Brett_Bleess
Former Employee
Former Employee

You may find the following area of Community useful too:

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

There are over 700 posts from our internal experts and most are how-to related, so be sure to check that area too, as you will likely be able to find something to give you some ideas on how to approach things.

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.