topic How to change a QVD?? in QlikView

How to change a QVD??

madhuqliklondon — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to add more fields to existing qvd,how can I do that ?

My dash board has few tables , one of the tables using a qvd which refresh every 30 mins, I want to add few fields to table which means I have to update qvd where it brings data from.

Re: How to change a QVD??

Anonymous — Fri, 19 May 2017 09:10:54 GMT

You want to add new columns or data?

Re: How to change a QVD??

swuehl — Fri, 19 May 2017 09:13:03 GMT

Not quite sure what your exact issue is.

There should be a QVW that writes that QVD, the 'creator'. If you can't locate this QVW, the creator should also be stated in the XML part of the QVD (e.g. by opening the QVD in a text editor).

Find the script part that creates and stores the table written to the QVD. Add the fields you want.

Re: How to change a QVD??

vikasmahajan — Fri, 19 May 2017 09:18:33 GMT

you need to find source from where qvd is generating and add few more columns which you want to add there it self.

Vikas

Re: How to change a QVD??

madhuqliklondon — Fri, 19 May 2017 09:22:07 GMT

new columns

Re: How to change a QVD??

Anonymous — Fri, 19 May 2017 09:24:48 GMT

Follow as Vikas and Stefan Suggested

Find out where it is generating from and add new columns over there

Re: How to change a QVD??

madhuqliklondon — Fri, 19 May 2017 09:29:12 GMT

Hi Stefan, .there is a orders dashboard which I think it self a qvw right ??, I have opened script editor in it , in one of the tabs there is load statement like field names from qvd. How to find out the 'creator' ??

Re: How to change a QVD??

Anonymous — Fri, 19 May 2017 09:34:06 GMT

Generally there will be one QVW which generates QVD's. Check where is that QVW and add new fields in it

Re: How to change a QVD??

madhuqliklondon — Fri, 19 May 2017 09:35:35 GMT

Hi, I have found the , opend qvd in note pad, it says creator file ...and location . I have located the file ,opened it , in script editor now, Bit confused there ..

Re: How to change a QVD??

Anonymous — Fri, 19 May 2017 10:10:59 GMT

What is your confusion?

Re: How to change a QVD??

madhuqliklondon — Fri, 19 May 2017 10:18:40 GMT

All the fields i wanted already exits in this qvw, so logically I just go to table properties identify the fields add them and reload dash board , is that correct??

Re: How to change a QVD??

tyagishaila — Fri, 19 May 2017 10:21:06 GMT

on scripteditor click on 'Table Files' button,

select qvd & click on Open button, now on File Wizard select XML radio button.

Here you can get creator of that qvd

Re: How to change a QVD??

Anonymous — Fri, 19 May 2017 10:26:05 GMT

Yes, Source it is already added new columns right?

Re: How to change a QVD??

madhuqliklondon — Fri, 19 May 2017 10:41:23 GMT

Columns already there not showing all the columns in qvd.

Re: How to change a QVD??

Anonymous — Fri, 19 May 2017 10:44:13 GMT

then, add all new columns in creator qvw and reload it.

Re: How to change a QVD??

madhuqliklondon — Mon, 22 May 2017 11:03:18 GMT

Thank you , It worked. Added columns and left it for automatic scheduled reload.