topic Re: Switch between SQL and QVDs in QlikView

Switch between SQL and QVDs

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

Would you please be able to help?

I have a project where I want create a switch between loading data from SQL Select or loading from QVD

ex;

(From SQL)

Table:

LOAD

SQL

Select

FROM

brs.qv_sales;

(From QVD)

Table:

LOAD

FROM

[$(vFileLocation)D_tSales.qvd]

(qvd);

So what I am trying to do is, create a variable if vLocation = 0 then load data from SQL, if vLocation = 1 then load data from QVD.

Is this possible, please help.

Re: Switch between SQL and QVDs

Anonymous — Mon, 05 Jun 2017 09:44:24 GMT

in frontend or script?

Re: Switch between SQL and QVDs

Mon, 05 Jun 2017 09:50:01 GMT

In script

Re: Switch between SQL and QVDs

PrashantSangle — Mon, 05 Jun 2017 09:52:38 GMT

Hi,

You can use IF Else in script.

Regards,

Prashant

Re: Switch between SQL and QVDs

PrashantSangle — Mon, 05 Jun 2017 09:56:44 GMT

syntax should be like

Set vLocation=1;

if '$(vLocation)' = '1' then

SQL Query;

else

QVD query

end if

Regards,

Prashant Sangle

Re: Switch between SQL and QVDs

jyothish8807 — Mon, 05 Jun 2017 10:21:11 GMT

Try like this:

LET vQVDcheck = isnull(QvdCreateTime('QVD Location'));

if $(vQVDcheck ) = -1 THEN

Load from SQL

else

ab:

Load from SQL;

concatenate

Load from QVD;

Store ab in to ab.qvd;

Br,

Re: Switch between SQL and QVDs

PrashantSangle — Mon, 05 Jun 2017 10:28:04 GMT

Hi,

You can also use Switch Case statement.

Syntax :

Let vLocation=1;

Switch vLocation

case 1 :

SQL Query;

case 2 :

Load Query;

End Switch;

Regards,

Prashant Sangle

Re: Switch between SQL and QVDs

Mon, 05 Jun 2017 12:26:32 GMT

Hi Prashant,

I have tried the Switch Case statement, but the queries will be a lot as I have a big dashboard, I mean with lots of scripts, and adding Switch Case to each and every query wouldn't look really appealing.

Am I correct that I will need to add the Switch Case statement in each query?

Re: Switch between SQL and QVDs

PrashantSangle — Mon, 05 Jun 2017 12:36:51 GMT

Yes..

Or you can create loop in if else clause.

Regards,

Prashant

Re: Switch between SQL and QVDs

Mon, 05 Jun 2017 14:41:16 GMT

You can try this by using variables. If you have 10 load statements, you need 10 variables.

The variable is initialised based on the vLocation. Some thing like below

if vlocation=1 then assign the below to vLoad1

"SQL

Select

FROM

brs.qv_sales;

if vlocation=0 then assign the below to vload1

LOAD

FROM

[$(vFileLocation)D_tSales.qvd]

(qvd);

then you can use the vLoad1 in the script.

hope this helps.