Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

tenyeapen
New 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.

1 Reply
Partner
Partner

Re: 2 columns from 2 query

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