topic Re: Binary load with variables in QlikView

Binary load with variables

Fri, 12 Feb 2016 20:09:10 GMT

while doing binary load ,variables are loaded not?

Re: Binary load with variables

nagireddy_qv — Fri, 12 Feb 2016 21:14:34 GMT

Hi,

No, variables wont come through when you do a binary load.

You can use the below solutions instead to ge the variables from one document to another.

you can load variables into a table in the source document and then retrieve them from the table (using peek()) in the target document.

You could use an include file to hold the variable definitions and then call the include file in both QVWS.

Re: Binary load with variables

dgreenberg — Fri, 12 Feb 2016 21:15:56 GMT

Binary load just loads the data nothing else.

Re: Binary load with variables

dgreenberg — Fri, 12 Feb 2016 21:16:25 GMT

If you want to reuse variables you should consider loading them from an Excel Sheet.

Re: Binary load with variables

maxgro — Fri, 12 Feb 2016 21:20:45 GMT

This is from Qlik help

The binary statement is used for loading the data from another QlikView document, including section access data. It does not load the layout information or variables. Only one binary statement is allowed in the script and it can only be put as the first statement of a script.

Re: Binary load with variables

Asad_Ullah23 — Fri, 21 Jul 2023 14:02:12 GMT

Hi, I am using Peek as the guys recommend but the variable not updating after the binary load:

Re: Binary load with variables

marcus_sommer — Mon, 24 Jul 2023 07:04:17 GMT

At first make sure that no other table exists which has the same data-structure as DateTable because this load wouldn't create the table else the records would be added to the existing table.

Further the syntax of peek() isn't quite right because the field-name as well as the table-name needs to be wrapped with single-quotes, like: peek('F', 0, 'T').

Beside this I assume that DateTable contains just a single record. In this case you don't need the variable-stuff else you could just refer to the fields itself.

Another consideration may go to the aspect if the referenced date-information shouldn't be already included within the master-calendar.

Re: Binary load with variables

Asad_Ullah23 — Mon, 24 Jul 2023 07:13:08 GMT

Thanks, Marcus for your answer.

I tried this way because the dashboard is built with variables so it has been used in so many places, so I thought to only change at the variable level ad rest with fit with that, but it is not happening, because the variable contains the value of day I publish the dashboard as binary and going forward variable not synch with date table value, even though its today date only but it is not updating in binary load case, Peek syntex working fine in my other server where binary load not happening, but I will give another try with your suggestion.

Thanks

Re: Binary load with variables

marcus_sommer — Mon, 24 Jul 2023 07:44:19 GMT

I'm not quite clear what you want to achieve. Your variable-values will be only updated if the source-qvd as well as dashboard are refreshed - which means it has to be scheduled on a daily level to get always an current value.

Re: Binary load with variables

Asad_Ullah23 — Mon, 24 Jul 2023 07:53:16 GMT

My purpose is very simple to update the variable value on a daily basis, and for that purpose, my dashboard reloads every day, but unfortunately, the variable value is not updating according to the date table value on a daily basis.

Thanks, Marcus

Re: Binary load with variables

marcus_sommer — Mon, 24 Jul 2023 08:44:22 GMT

If the dashboard reloads every day and the variable isn't changing it means that the qvd as variable-source isn't updated. Therefore you need to go to the process which creates the qvd to look how it's done and what might be wrong with it.