topic Meta data about concatenated facts in QlikView

Meta data about concatenated facts

pernillet — Mon, 26 Jan 2026 18:19:17 GMT

Is there any system function or simular, that can show which fields are in a concatenated fact and from which origin/table they come from ?

Like this:

Table1:

Load

"1" as Factname

From xx1;

Concatenate (Table1)

Load

"2" as Factname

From xx2;

Concatinate (Table1)

Load

"3" as Factname

From xx2;

I would like the result:

Field:　　　　　　　　　　　　 Factname

A　　　　　　　　　　　　　　　　　　　　　　　　　 1,2,3

B　　　　　　　　　　　　　　　　　　　　　　　　　 1,2,3

C　　　　　　　　　　　　　　　　　　　　　　　　　 1

D　　　　　　　　　　　　　　　　　　　　　　　　　 2

E　　　　　　　　　　　　　　　　　　　　　　　　　　3

Re: Meta data about concatenated facts

rubenmarin — Wed, 19 Aug 2020 15:15:52 GMT

Hi, I think there is no built-in possibility, you need to add an 'origin', 'source', 'factname' or similar field to keep the trace of where the values are coming.

Re: Meta data about concatenated facts

Brett_Bleess — Thu, 03 Sep 2020 13:01:11 GMT

Have a couple of things, but not sure they are going to be of much help:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Table-Viewer/ba-p/1474304

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/System_fields.htm

That is about it in the way of additional info of which I can think.

Regards,
Brett