topic Re: Binary Load(urgent) in QlikView

Binary Load(urgent)

Thu, 18 Oct 2012 10:16:48 GMT

Is it possible to do a conditional binary load based on the value of a variable.

Ex: if(v1=0, binaryload1, binaryload2)

Re: Binary Load(urgent)

thomas_skariah — Thu, 18 Oct 2012 10:52:18 GMT

Hi,

You can use the following code.

BINARY $(vbinary);

let vbinary = if(vtest=1,'C:\Documents and Settings\My Documents\Qlikcommunity\test3.qvw',

'C:\Documents and Settings\My Documents\Qlikcommunity\test2.qvw');

Use a input box at front end whether you want 1 or 0

Regards,

Tom

Re: Binary Load(urgent)

Thu, 18 Oct 2012 11:09:10 GMT

Thanks Tom for the Reply. If u can post a qvw file showing the implementation, then it would be really helpful.

Re: Binary Load(urgent)

Thu, 18 Oct 2012 12:04:56 GMT

Hi,

It loaded the file corresponding to vtest<>1.

How to make vtest=1 ?

tried declaring a variable in front end with name vtest bt no use.

Regards

Re: Binary Load(urgent)

thomas_skariah — Thu, 18 Oct 2012 13:46:00 GMT

Hi,

Please find the attached application.

Regards,

Tom

Re: Binary Load(urgent)

hugmarcel — Fri, 31 May 2013 18:24:00 GMT

you can also do a conditional binary load in this way:

1.) In the GUI,define a variable vBinaryLoad with value "BINARY 'mytable.qvw';" (without double-quotes)
2.) As first script command write $(vBinaryLoad)
3.) Change vBinaryLoad anywhere and your load will be conditional.

Marcel