topic How to store QVD into path set by variable in QlikView

How to store QVD into path set by variable

Anonymous — Thu, 04 Jan 2018 15:24:46 GMT

I'm trying to store a QVD into a file path set by a variable. Here is what I have so far:

In the include file- Set vQVDPath_ExchangeRate= "(private path)\Exchange Rates.qvd";

In the script- $(Include=..\InputFiles\vQVDPath_ExchangeRate);

Then I try to store the QVD like so: STORE [Exchange Rate] INTO vQVDPath_ExchangeRate (qvd);

This doesn't work. What am I doing wrong?

Re: How to store QVD into path set by variable

Miguel_Angel_Baeyens — Thu, 04 Jan 2018 15:27:56 GMT

You need to expand the variable, looking like this

STORE [Exchange Rate] INTO [$(vQVDPath_ExchangeRate)] (qvd);

If you want to see the contents of the variable, either debug instead of run from the script editor, and you can set a break point on the SET instrucion or the $(Include=) and see whether the value is properly populated

Re: How to store QVD into path set by variable

sunny_talwar — Thu, 04 Jan 2018 15:28:49 GMT

May be try this

STORE [Exchange Rate] INTO '$(vQVDPath_ExchangeRate)' (qvd);