topic Re: Find qvd source in App Development

Find qvd source

jpjust — Mon, 19 Apr 2021 19:58:06 GMT

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

Re: Find qvd source

JordyWegman — Mon, 19 Apr 2021 20:46:35 GMT

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

Re: Find qvd source

jpjust — Mon, 19 Apr 2021 21:13:32 GMT

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?

Re: Find qvd source

JordyWegman — Tue, 20 Apr 2021 05:14:15 GMT

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

Re: Find qvd source

MayilVahanan — Tue, 20 Apr 2021 06:39:31 GMT

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.

Re: Find qvd source

jpjust — Tue, 20 Apr 2021 13:40:14 GMT

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

Re: Find qvd source

MayilVahanan — Wed, 21 Apr 2021 01:25:38 GMT

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

Re: Find qvd source

jpjust — Wed, 21 Apr 2021 14:16:39 GMT

Thanks much!