topic Re: Parameter and empty value in QlikView

Parameter and empty value

Anonymous — Fri, 13 Jul 2012 14:18:12 GMT

Hello,

I'm QlikView begginer. I can reload QVW with many different databases. I can set the database by command line parameter:

"c:\Program Files\QlikView\qv.exe" /r /vDB=DB1 j:\QLIKVIEW\DEVELOPMENT\TEST.qvw

In case the parameter is'nt set (by reload from Desktop), I can use the deafult database.

I have this line before connect to database:

IF (Len(Trim(DB))=0 or IsNull(DB)) THEN

SET SetDB = 'DB0';

ELSE

SET SetDB = $(DB);

ENDIF;

Then I connect to SetDB database.

But... SetDB is already set as DB0, so script don't take the value from parameter DB. Do you see some mistake? Can you help me?

Many thanks,

Olda

Re: Parameter and empty value

CELAMBARASAN — Fri, 13 Jul 2012 14:42:22 GMT

Hi,

Its because previously assigned values is stored in that variable

set variable for the DB after

IF (Len(Trim(DB))=0 or IsNull(DB)) THEN

SET SetDB = 'DB0';

ELSE

SET SetDB = $(DB);

ENDIF;

SET DB=;//or LET DB = Null();

Re: Parameter and empty value

Anonymous — Sat, 14 Jul 2012 06:36:06 GMT

Thanks,

I tried it. I have the same results: already DB0. I think, I have the opposite problem, I have in condition the empty DB - parameter from command line not set it.

Do you have any idea?

Re: Parameter and empty value

Anonymous — Mon, 16 Jul 2012 21:19:57 GMT

Hello,

I found many possibilities how to set the parameter. Finally I has a correct script:

LET SetDB=NULL(); // delete old value

IF (Len(Trim(DB))=0 or IsNull(DB)) THEN

LET SetDB = 'DB0';

ELSE

LET SetDB = $(DB);

ENDIF;

LET DB=NULL(); //delete old value

VERY IMPORTANT! I have to add new parameter DB into Settings - Variable Overview! My parameter did'nt exist before.