topic Re: Binary inside IF in QlikView

Binary inside IF

Fri, 06 Nov 2015 17:33:01 GMT

Hello;

I'm trying reload a QVW file with the Binary sentence. But I need change the qvw file depending on the value of a variable.

I tried many things but I didn't success.

The script I have is soemthing like this:

IF vR=0 THEN

Binary [\\PATH\QLIKVIEW.qvw];

ELSE

Binary [\\PATH\QLIKVIEW2.qvw];

ENDIF

If I run this script I have this error message:

Unknown Sentence

Binary [\\PATH\QLIKVIEW.qvw]

If I run the script without the IF condition goes well.

I tried include the sentence in a text file and call it by: $(Must_Include=..\Scripts\Script1.txt);

This didn't go well.

I hope someone knows what I'm doing wrong. Is not valid writing poor English 🙂

Thanks,

Fernando

Re: Binary inside IF

Anonymous — Fri, 06 Nov 2015 17:41:56 GMT

Hello Fernando,

I think Binary Load must be the first sentence in the script, and only one is allowed in the script.

I can't think in a way to have 2 different binarys in the same script.

Regards,

Gabriel

Re: Binary inside IF

swuehl — Fri, 06 Nov 2015 17:42:54 GMT

What if you - instead of setting vR to 0 or something else - define a variable with the qlikview file name to load?

Binary [\\PATH\$(vFile)];

Re: Binary inside IF

prabhu0505 — Fri, 06 Nov 2015 17:52:15 GMT

Are you passing the value for vR from publisher?

Re: Binary inside IF

swuehl — Fri, 06 Nov 2015 17:57:57 GMT

You can also look into the solution suggested by Maxgro here:

Re: BINARY load with dynamic file name

This involves another QVW, so in server environment, you may need to first reload the first QVW with your vR passed to generate the include file, then reload the QVW with the include statement to execute the chosen binary.

Re: Binary inside IF

tamilarasu — Sat, 07 Nov 2015 12:21:51 GMT

Hi Fernando,

As per my knowledge, the binary statement must be the first statement in the LOAD script. so you cannot use it by preceding any other statement. This is applicable for the hidden script.

Seems you are not using any hidden script in the application. My suggestion is create an another variable something like,

Variable Name -> vFileName

Definition -> =if(vR=0, 'File1','File2')

Then use the binary load as (should be very first statement)

Binary [\\Path\$(vFileName)];

Let me know.

Re: Binary inside IF

Mon, 09 Nov 2015 09:17:14 GMT

Thanks Gabriel

I didn't remember that the senetnce Binary in the script must be the first.

I did it with a variable.

Thank you very much,

Fernando

Re: Binary inside IF

Mon, 09 Nov 2015 09:19:44 GMT

Thanks swuehl

I did it with a variable.

Thank you very much,

Fernando

Re: Binary inside IF

Mon, 09 Nov 2015 09:20:35 GMT

Thanks Saravana

The problem was that the sentence Binary, in the script, must be the first.

I did it with a variable.

Thank you very much,

Fernando

Re: Binary inside IF

Mon, 09 Nov 2015 09:21:23 GMT

Thanks Tamil

I didn't remember that the sentence Binary in the script must be the first.

I did it with a variable as you told me.

Thank you very much,

Fernando

Re: Binary inside IF

Tue, 23 Feb 2016 13:49:51 GMT

Was anyone able to get the variable used in a binary working? I keeping getting an error.

The value for my variable is: =if(ComputerName()='ABC','v:\models\modelRevenue.qvw','v:\models\modelRevenue.qvw')

My binary statement: binary $(vbinarypath);

If I change my variable to just be the file path/name it works fine.

Any help is appreciated.

Re: Binary inside IF

swuehl — Tue, 23 Feb 2016 20:31:31 GMT

If you run your script in debug mode, to what statement is your first line with the dollar sign expansion expanded?

What is the error message you get?

Re: Binary inside IF

Wed, 24 Feb 2016 17:18:48 GMT

When I click Debug the following error immediately comes up:

Cannot open file 'W:\applications\00.DirectPublished\Revenue\=if(ComputerName()='ABC','v:\models\modelRevenue.qvw','v:\models\modelRevenue.qvw')'

binary =if(ComputerName()='ABC','v:\models\modelRevenue.qvw','v:\models\modelRevenue.qvw')

Re: Binary inside IF

swuehl — Wed, 24 Feb 2016 17:55:36 GMT

Seems like your variable is expanded to the expression, not to the evaluated value.

(and I think that's how it's done when you call the variable from the script context)

Maybe Fernando can clarify how he's done the implementation.

Re: Binary inside IF

swat_agar — Tue, 06 Oct 2020 06:30:17 GMT

Hi,

The above is not working. I am creating a variable from the variable overview and using that in the binary load statement. But, the variable expression does not get evaluated and in Binary load statement, it gives me the error because it is not taking the expression as a string instead of it's evaluated value.