topic Re: custom filed associate in QlikView

custom filed associate

Wed, 25 Nov 2020 16:16:04 GMT

I'm a newbie on qlikview. I have search around in google and not found the answer.

In my case， there are the table for example.

tableA：

field_n, field_a

tableX：

field_n, field_x

tableY：

field_n, field_y

On the other hand, not all value that in the tableA.field_n exist in the tableX.field_n or tableY.field_n.

I want to associate file_n between tableA and tableX， tableA and tableY, but not tableX and tableY,

and I need a list table with tableA， to filter record in tableX and tableY.

After try with mapping and alias filed_n with different field name, then I have no any idea.

Thanks for any help.

Re: custom filed associate

agomes1971 — Fri, 02 Sep 2016 15:11:38 GMT

Hi,

sorry I think is easier to do like this:

TableA：

field_n, field_a;

concatenate

TableX：

field_n, field_x

conacatenate

TableY：

field_n, field_y

and then make a list.

HTH

André Gomes

Re: custom filed associate

sunny_talwar — Sat, 03 Sep 2016 17:57:38 GMT

Not 100% sure, but may be something like this:

tableA:

LOAD field_n,

field_a,

field_n as field_AX,

field_n as field_AY

tableX:

LOAD field_n,

field_x,

field_n as field_AX

tableY:

LOAD field_n,

field_y,

field_n as field_AY

Re: custom filed associate

Mon, 05 Sep 2016 06:30:02 GMT

Thanks at first.But I can not change the table layout with some reason.