Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sheetal
Contributor II
Contributor II

How to get the data source information

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.

 

 

Labels (1)
4 Replies
JordyWegman
Partner - Master
Partner - Master

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

Work smarter, not harder
Sheetal
Contributor II
Contributor II
Author

Thanks. Will do so.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
MVP
MVP

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.