topic Re: Qlik associations multiple fields in App Development

Qlik associations multiple fields

snancyiv — Mon, 07 Nov 2022 15:57:21 GMT

Hi everyone,

I have 2 source files in my Qlik app and I'm currently associating them by discharge date. However they also have other similar fields which end-user should also be able to filter the data by (discharge status, service line, diagnosis code). Unfortunately, the dashboard is not functioning that way. It doesn't seem like Qlik can associate more than 1 field. What's the best way to go about this? I originally thought it can identify similar fields, but it's not doing so.

Thanks in advance!

Re: Qlik associations multiple fields

hic — Tue, 08 Nov 2022 09:30:28 GMT

You can associate two tables using multiple fields. That shouldn't be any problem.

However, in your case it sounds as if it would be better to concatenate the two source files into one table.

Re: Qlik associations multiple fields

snancyiv — Tue, 08 Nov 2022 14:02:51 GMT

Thanks @hic . How do I associate multiple fields? By creating a compound key?

Re: Qlik associations multiple fields

hic — Wed, 09 Nov 2022 07:43:24 GMT

It will happen automatically and create a synthetic key - and these are usually NOT dangerous as many people claim. Just make sure that the fields exist in both tables and are named the same.

A compound key that you create is also a good solution.

Re: Qlik associations multiple fields

snancyiv — Sat, 03 Dec 2022 19:44:56 GMT

Thank you this was helpful. It worked out perfectly!