How to get the data source information

[Sheetal]

Hello

Is there a way to find out the datasource of the fields in the visulalizations. I have loaded multiple datasets for one app. For example in the table object below the total attendees measure = Count(attendeenum), the attendeenum field is in multiple datasets .

Date                      |              Total Attendee          

Sep-2018                             2000

Oct 2018                              1000

How can I know which dataset the field is coming from? I tried to look in the properties panel but I do not see any field which displays which dataset the field comes from. Can someone please help.

[JordyWegman]

Hi,

This is not possible. This is why developers always note the source in the name. For example, when you load a dataset from SAP, like a sales table we name it QSLSXX_SAP_ATTENDEENUM. This way we always know what the source is.

I recommend to also do this, although this can take some work if you haven't done this from the start. But this will save you a big headache 😉

Jordy

Climber

[Sheetal]

Thanks. Will do so.

[rwunderlich]

There is nothing native in the product that will give you this info.  However an excellent third party product is NodeGraph https://www.nodegraph.se/ which does provide field level lineage. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Vegar]

An alternative but similar solution to @JordyWegman suggestion is to create a row source to tabel.

Transaction:
Load Date, Atendeee, 'SAP' as TransactionSource
From SAPSource
;
Concatenate
Load Date, Atendeee, 'HubSpot' as TransactionSource
From hubSpotSource
;

Then you could make a selection in the transaction Source to investigate the impact of each source.