Find qvd source

[jpjust]

Hi All,

I am using qliksense. I have few qvd's generated by qvf's.

How can I find the source qvf files for the qvd's?

In qlikview, there is an lineage tool comes in handy to find such information

Thanks

[JordyWegman]

Hi,

You could use NodeGraph or Platform Manager for this. Otherwise, you could check the logs yourself to see where it's coming from. Otherwise it's pretty hard..

Jordy

Climber

[jpjust]

Thanks Jordy.

Do you have more details on find that info from the logs? Which log I should scan through? Is it the script log of the qvf that reads the qvd?

[JordyWegman]

Hi,

It's the script logs of the QVF that creates QVDs. Are you using Desktop or Server of Qlik Sense?

Qlik Sense Desktop Logs:

C:\Users\<username>\Documents\Qlik\Sense\Log

Qlik Sense Server Logs:

C:\ProgramData\Qlik\Sense\Log\Script

Jordy

Climber

[MayilVahanan]

Hi @jpjust 

You can find the QVD created file (qvf file) with help of metadata - <CreaterDoc>. 
Change the file format from QVD to Delimited to see the metadata.

[jpjust]

Hi Mayil,

I believe it works. I will test few more.

Is it possible to copy the ID to search quickly?

Also, what is the quickest way to find the app? I usually search in QMC. Apps -> Search by adding ID as column selector.

Thanks

[MayilVahanan · Accepted solution]

Hi @jpjust 

Try like below

Load *, 'https://urdomain.com/sense/app/'&Applink as Link where Len(Trim(Applink))>0;
LOAD
[<?xml version="1.0" encoding="UTF-8" standalone="yes"?>],
TextBetween([<?xml version="1.0" encoding="UTF-8" standalone="yes"?>], '<CreatorDoc>','</CreatorDoc>') as Applink
FROM [lib://vNewProdQVDPath/YourQvdFileName.QVD]
(txt, codepage is 1252, embedded labels, delimiter is \x0);

Link <- its provide the app link

[jpjust]

Thanks much!