topic Re: 2 columns from 2 query in QlikView

2 columns from 2 query

tenyeapen — Tue, 14 Jan 2020 07:20:35 GMT

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.

Re: 2 columns from 2 query

dplr-rn — Tue, 14 Jan 2020 14:57:10 GMT

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

Re: 2 columns from 2 query

Brett_Bleess — Tue, 11 Feb 2020 21:49:36 GMT

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