topic Re: how to display a qvd name in a text box? in QlikView

how to display a qvd name in a text box?

Anonymous — Fri, 07 Nov 2014 21:13:14 GMT

Hi,

I need to display the Qvd name in the text box.

I have tried documentname function but it is showing the qvw not qvd.

Can some one help me pls.

Regards,

Sharma.

Re: how to display a qvd name in a text box?

danieloberbilli — Fri, 07 Nov 2014 21:17:24 GMT

I think there is no function for that. Maybe write the file name ( your qvd) in a variable to show it in a textbox

Re: how to display a qvd name in a text box?

Anonymous — Fri, 07 Nov 2014 21:26:31 GMT

Hi ,

I have given as let vQVDName = Filename('my qvd name')

called the vQVDName in the text box to display my qvd name but it is not displaying

Any idea why?

Regards,

Sharma.

Re: how to display a qvd name in a text box?

danieloberbilli — Fri, 07 Nov 2014 21:31:52 GMT

No, as far as I know there is no function like what you describe as Filename.

I suggest you set the name fix in the variable: e.g.

SET vQVDName = 'MyQvdName' ;

Re: how to display a qvd name in a text box?

preminqlik — Fri, 07 Nov 2014 21:37:36 GMT

dude use document Analyzer qvw to get table names and fieldnames which can be called in front end in text box whatever

Re: how to display a qvd name in a text box?

Anonymous — Fri, 07 Nov 2014 21:41:44 GMT

hi,

I cant use 'set' as i have many QVDs which i want to display the updated qvd info at dashboard.

Re: how to display a qvd name in a text box?

MarcoWedel — Fri, 07 Nov 2014 21:48:19 GMT

Hi,

as qvd loads per default create tables named after the file, you might display the table name instead (if not changed manually in the script):

LOAD *
FROM [http://community.qlik.com/servlet/JiveServlet/download/574248-117072/dot_actie.qvd] (qvd);

hope this helps

regards

Marco

Re: how to display a qvd name in a text box?

Anonymous — Fri, 07 Nov 2014 22:01:30 GMT

hi,

It is showing the system table not the one i created.

Re: how to display a qvd name in a text box?

MarcoWedel — Fri, 07 Nov 2014 22:37:54 GMT

please post your application with sample data to clarify

Re: Re: how to display a qvd name in a text box?

Anonymous — Fri, 07 Nov 2014 22:56:37 GMT

Hi,

I cant able to attach my qvw?

Can i show u in my team viwer if it is ok?

Re: how to display a qvd name in a text box?

Anonymous — Fri, 07 Nov 2014 23:05:24 GMT

Juat a minute i am sending my qvw.

Re: Re: how to display a qvd name in a text box?

Anonymous — Fri, 07 Nov 2014 23:18:08 GMT

Pls find the attached QVW where i need to display the QVD along with last updated QVD reload time.

Thanks,

Sharma.

Re: Re: how to display a qvd name in a text box?

Sat, 08 Nov 2014 06:07:41 GMT

use

qvdtablename(file.qvd) it wil return the table name of the qvd.

Re: Re: Re: how to display a qvd name in a text box?

ashfaq_haseeb — Sat, 08 Nov 2014 08:11:22 GMT

Hi,

Try with FileBaseName()

Have a look at attached application.

Let me know if that worked.

Regards

ASHFAQ