topic Re: Match Multiple Columns in QlikView

Match Multiple Columns

QV_User — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I am looking for a solution on the below, I need QV to match COUNTRY and Contract#. However if there's no contract No. there is a generic contract.

I feel this is failing because of the use of multiple countries and f.e. if the COUNTRY is US in combination with the generic contract it shows, however if the COUNTRY is CA it will not.

Can you help me out here?

Re: Match Multiple Columns

rubenmarin — Tue, 01 Oct 2019 19:31:49 GMT

Hi, can you post a sample that shows your issue.

Maybe you can create a compsite key:

Country &'_'& Contract as IdContract

This creates a field that combines both fields

Re: Match Multiple Columns

QV_User — Tue, 01 Oct 2019 21:15:32 GMT

Hi,

Have tried that already.

I have no specific example as I have an ODBC connection running in the background.

Re: Match Multiple Columns

rubenmarin — Wed, 02 Oct 2019 06:48:29 GMT

Hi, I don't need real data, just an example (qvw or text explanation) of your issue and how is managed the generic contract

Re: Match Multiple Columns

rubenmarin — Wed, 02 Oct 2019 06:50:11 GMT

BTW, If there is no sensitive data you can upload your qvw to take a look of what is happening, having an ODBC doesn't matter, just I can't make reloads but I can see what are you trying to do.