Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
while doing binary load ,variables are loaded not?
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.
Binary load just loads the data nothing else.
If you want to reuse variables you should consider loading them from an Excel Sheet.
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.
Hi, I am using Peek as the guys recommend but the variable not updating after the binary load:
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.
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
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.
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