topic How to Generate QVD after every reload in App Development

How to Generate QVD after every reload

ashish1504 — Thu, 27 Oct 2022 04:05:53 GMT

Hi Can anyone help with How to generate QVD file after every reload.

I am trying to do but getting and error

Semantic error

call StoreAndDropTable ('A_PRODUCT','QVD\A_PRODUCT')

Below is the statement i have used.

"call StoreAndDropTable ('PRODUCT','$(PathQVD)PRODUCT');"

Re: How to Generate QVD after every reload

Vegar — Thu, 27 Oct 2022 04:23:10 GMT

StoreAndDropTable is not a built in functionality. You need to have a sub named StoreAndDropTable to run your script as it is.

However you could try to do this instead:

Store PRODUCT into $(PathQVD)PRODUCT.qvd (qvd);

Drop table PRODUCT;

Re: How to Generate QVD after every reload

ashish1504 — Thu, 27 Oct 2022 08:17:43 GMT

Hi @Vegar ,

I have tried your suggestion but it is not working.

Can you tell me how to do this "StoreAndDropTable is not a built in functionality. You need to have a sub named StoreAndDropTable to run your script as it is."

Because i am new in QlikView. Thank you in advance

Re: How to Generate QVD after every reload

MayilVahanan — Thu, 27 Oct 2022 08:41:46 GMT

StoreAndDropTable not built-in functionality.

However its sub routine.

Sub..end sub ‒ QlikView