topic Re: conditional include statement in QlikView

conditional include statement

Fri, 03 Jul 2015 13:38:25 GMT

if we if condition

if ( compname() 'test') then

one include statement has to execute

else

another include statement has to execute

this is my concern ,

please help me in this .

i tried from my side but only my else statement working .

Re: conditional include statement

alexandros17 — Fri, 03 Jul 2015 13:42:19 GMT

if (condition, true, false)

this is the syntax to be used

Re: conditional include statement

Anonymous — Fri, 03 Jul 2015 13:44:27 GMT

can you Show your complet if Expression

compname is not a function (or is it a macro?),

and copname Needs a comparison (or you just forgot it)

if (compname='test' then

include1

else

include2

endif

what does compname contains?

Re: conditional include statement

Fri, 03 Jul 2015 13:54:07 GMT

thanks for your reply ,

see basically i m using

if condition and in that i m including the include statement which has the qvs scripts

i have two include statement which has two qvs scripts based on condition it should take

first condition then it execute , or else it should execute the else statement include statement .

problem is that if it passes the condition then it should execute the first condition or else else condition

but only else statement is executing

ex :

IF wildmatch(ComputerName(),'*QVTEST*','*QVDEV*') THEN

$(must_include=\\computer\Qlikview Dashboard Template.qvs);

ELSE

$(must_include=\\computer\Qlikview Dashboard Template.qvs);

Re: conditional include statement

alexandros17 — Fri, 03 Jul 2015 13:57:17 GMT

If Month(Today())=7 then
$(Include=..\_Common Code\Source\Variables Main.txt);
$(Include=..\_Common Code\Source\Variables Shared.txt);
$(Include=..\_Common Code\Source\Document Changes.txt);
ELSEIF
....

ENDIF

Re: conditional include statement

Anonymous — Fri, 03 Jul 2015 14:07:48 GMT

your Statement looks good so far

what are the values for computername?

Re: conditional include statement

jonathandienst — Fri, 03 Jul 2015 14:12:31 GMT

The two include statements include the same file. and (I think) they cannot be empty.

And you need an End If (or ENDIF) statement after the second include.

Re: conditional include statement

sasiparupudi1 — Fri, 03 Jul 2015 14:13:27 GMT

IF wildmatch(ComputerName(),'*QVTEST*','*QVDEV*')=1 THEN

EXECUTE file on *QVTEST*

ELSE

EXECUTE file on *QVDEV*

ENDIF

Re: conditional include statement

settu_periasamy — Fri, 03 Jul 2015 14:14:45 GMT

Hi,

Your TRUE and FALSE include statment looks same to me. or am i look wrong?

but only else statement is executing

ex :

IF wildmatch(ComputerName(),'*QVTEST*','*QVDEV*') THEN

$(must_include=\\computer\Qlikview Dashboard Template.qvs);

ELSE

$(must_include=\\computer\Qlikview Dashboard Template.qvs);