topic Re: Selecting required qvd's from a location while reload in QlikView

Selecting required qvd's from a location while reload

rsdhavle — Fri, 24 Jan 2014 12:34:34 GMT

Is there any way to select particular qvd's while reloading data?

Example:

I have some qvd's available on one folder location

D:\ qvd1

qvd2

qvd3

qvd4 etc

While reloading the data i need to load data of qvd 3 only and i have to make this option available while reloading so that user can select qvd 1,2 or 3 whatever according to his preference. Is there any way to do so?

If yes What is the code needs to be written in the script?

Re: Selecting required qvd's from a location while reload

ashwanin — Fri, 24 Jan 2014 12:38:29 GMT

you can do it by Just reloading the qvd by selecting one by one. Else put qvd's in a folder, with some specific name and e.g 201201 to 201212 for 2012 and 201301 to 201312 for 2013 qvds.

Now if you want to reload only 2013 qvds's then at the time of reload just put path\2013*qvd

Re: Selecting required qvd's from a location while reload

ashwanin — Fri, 24 Jan 2014 12:40:21 GMT

example

Load

as,

dgh

FROM

(qvd);

Re: Selecting required qvd's from a location while reload

alexandros17 — Fri, 24 Jan 2014 12:53:05 GMT

Use

Input(str cue [, str caption])

This function can be used in the
script only and opens an input box that prompts the user for a value during the
script execution. The parameters cue and caption are used as message and caption
texts, respectively. The function returns the entered value.

The input box function returns
NULL if the dialog is cancelled, closed or cannot be shown.

Example:

Load
Input('Enter value', 'Input box') as v,
Recno () as r

autogenerate 3;

Re: Selecting required qvd's from a location while reload

rsdhavle — Fri, 24 Jan 2014 13:13:51 GMT

HI,

Thanks. Can you please tell me where should i mention the folder location from which one of the qvd file needs to be picked up?

Re: Selecting required qvd's from a location while reload

ashwanin — Fri, 24 Jan 2014 13:45:58 GMT

In Script

Re: Selecting required qvd's from a location while reload

rsdhavle — Fri, 24 Jan 2014 14:08:50 GMT

Hi AShwani,

You are telling about simple load from qvd i want the approach which Alessandri is talking about as i need select qvd's dynamically while reloading

Re: Selecting required qvd's from a location while reload

alexandros17 — Fri, 24 Jan 2014 14:23:57 GMT

Here is a complete example

Hope it helps

LOAD Input('Enter value', 'Input box') as v autogenerate 1;

LET myFolder = Peek('v');

DROP Table TMP;

DDD:

NoConcatenate

LOAD * Resident $(myFolder);