Having problem while selecting multiple tables all at a time..

[nikhilgarg]

HEy,

When i choose any database (say having 50 tables)  and i have to select 15 tables in qlikview then i can not select them all at a time . I will have to select all 15 tables one by one. Is there any way to select all 15 tables all at a time ??

Please help.

Thanx.

[nikhilgarg]

Ohk thanx   But why do we need to create it in separate variable. We can do this in a step above also  , right ??

[jagan]

Hi,

one for getting actual database table name and another for QVD name.

LET vMyTableName = 'dbo.[' & Peek('TableNames', $(i), 'SQLTableList') & ']'; --  SQL Table Name

LET vMyTableNameQVD = Replace(Peek('TableNames', $(i), 'SQLTableList'), ' ', ''); - Genrates QVD name to be generated

Regards,

Jagan.

[nikhilgarg]

yOu mean to say that we use qvd's bcoz they contain data in reduced form. So we are removing it in second step. Although we can do it  in previous step also but no required. Right ??

In LET vMyTableNameQVD = Replace(Peek('TableNames', $(i), 'SQLTableList'), ' ', '');:

We are fetching table name that contains data but with no spaces or commas . Right ??

[jagan]

To reduce the database hits we are using QVDs.

We are generating a QVD name with no empty spaces.

Regards,

Jagan.

[nikhilgarg]

HEy ,

THanx jagan. NOw i understand the whole working of the code. But a last question:

In the following:

STORE $(vMyTableNameQVD) INTO $(ExtractQVD)$(vMyTableNameQVD).QVD;

WHat is the working of :   $(ExtractQVD) ??

[jagan · Accepted solution]

Hi Nikhil,

It is the file path for example C:\Qlikview\, instead of hard coding we are maintaining this in variable.

Please close this thread if you got the solution by giving Correct and Helpful answers to the helpful posts.

Regards,

jagan.