topic Re: One app loading BINARY from another in QlikView

One app loading BINARY from another

datanibbler — Thu, 21 Aug 2014 14:31:45 GMT

Hi,

I have two apps with personell data - one with all the names and one without any names.

For reasons of data_protection, names should only be available for HR_personell. I could not, however, implement an OMIT_field in the SA since all the apps are being reloaded by a server_user, so that's not an option - for that reasin, I have two apps, with one

loading the data_model BINARY from the other and all the same charts.

<=> Still, in one chart, the "primary" app shows current data and the "secondary app", though the formulas are all exactly the same and the data_model is necessarily so, does not - in fact, when I look at it, there is data only up to the beginning of June.

Does anyone have an idea where I should look for the error here?`

Thanks a lot!

Best regards,

DataNibbler

Re: One app loading BINARY from another

datanibbler — Thu, 21 Aug 2014 14:37:17 GMT

Ah - I have found a clue:

For some reason, a date_variable >> v_today << that is coming from a master_calendar (an INCLUDE script) was set to June6. I cannot think of a reason for this - the app is of course reloaded daily, and I have just tried this out on its own - in a new app, I just loaded that INCLUDE - and the variable v_today showed August_21, just like it should.

I cannot make head or tail of this.

Can you?

Re: One app loading BINARY from another

rwunderlich — Thu, 21 Aug 2014 14:52:04 GMT

BINARY does not load variables, only data. So the v_today value is whatever was leftover the last time it was set.

You should reestablish all variables after the BINARY load.

-Rob

Re: One app loading BINARY from another

datanibbler — Thu, 21 Aug 2014 14:56:54 GMT

Hi Rob,

ah - er, yes. I knew that at a point. I must have forgotten in the meantime.

I will try - in principle, if I implement anew the INCLUDE (the master_calendar and the date_variables), that should re-establish the variables, no? And the master_calendar should just replace the one I have loaded BINARY from the other app. Let's see.

Many thanks!

Best regards,

DataNibbler