topic Re: Same App has value differences when opened in AP and Client... in QlikView

Same App has value differences when opened in AP and Client...

Mon, 26 Jan 2026 18:19:17 GMT

Hello People,

It baffles me a lot that the same application on the access point has some disparity in some value when viewed against the desktop application. I read a thread where I would have to delete .Shared files but is to no avail.I think when I reload the the Desktop Application updates whilst the server does not.

Anyone else has a clue or idea of what is happening?

Thanks

Re: Same App has value differences when opened in AP and Client...

Gysbert_Wassenaar — Tue, 28 Oct 2014 15:05:31 GMT

If you reload your local document and don't reload the document on the server then there's a good chance that your document will have different data then the document on the server.

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 15:09:22 GMT

I did reload both applications. In fact I have reloaded several times simultaneously.

Re: Same App has value differences when opened in AP and Client...

ashfaq_haseeb — Tue, 28 Oct 2014 15:16:33 GMT

Hi,

Make sure allow session recovery is uncheck

Regards

ASHFAQ

Re: Same App has value differences when opened in AP and Client...

Peter_Cammaert — Tue, 28 Oct 2014 15:17:19 GMT

Are you using Section Access / Data Reduction / Macros / anything else that might behave differently in the AP vs Desktop?

Note that the AP might remember some things you have done / selected during a previous session.

Re: Same App has value differences when opened in AP and Client...

Gysbert_Wassenaar — Tue, 28 Oct 2014 15:18:53 GMT

It's still possible for differences to occur if other processes enter or change data in your source database. If you can rule that out as a possible cause and you are sure that both document contain the exact same data from the same source and that the two documents are otherwise identical, i.e. the same variables with the same values, the same expressions in the charts and the same active selections, no reduction from section access or otherwise then you have a minor miracle on your hands.

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 15:24:27 GMT

Are you allowing multiple copies in memory? I have seen that option cause problems in the past and pickup previous sessions etc

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 15:40:21 GMT

Hi ASHFAQ

How do I uncheck session recovery

Hi Gysbert

I can confidently rule out all that. It's just a copy of the application in the development area to the live environment and

all pointing to the same source files.

Hello Peter,

So forgetful of me i have deployed section access on the server and not on the Desktop. But how would that affect anything my profile has all the exemptions.Okay I will review the section access again.

Re: Same App has value differences when opened in AP and Client...

ashfaq_haseeb — Tue, 28 Oct 2014 15:48:47 GMT

Hi check this.

http://community.qlik.com/message/643219#643219

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 15:57:30 GMT

Hi Joe

Only one copy of document in memory setting is checked.

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 16:00:08 GMT

hmm what version are you running? And when did you last restart services?
I remember something a while back similar to this and only way to sort it was a restart (typical IT I know). After that we just set a nightly task to restart services

hope that helps

Joe

Re: Same App has value differences when opened in AP and Client...

Peter_Cammaert — Tue, 28 Oct 2014 16:28:49 GMT

Section Access may, amongst others, reduce data for you in the AP while in QV Desktop you may be granted access to all of it. Very annoying at times.

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 16:31:01 GMT

Version 11.0.11440.0 and I have restarted more than thrice already.

Re: Same App has value differences when opened in AP and Client...

ashfaq_haseeb — Tue, 28 Oct 2014 16:38:21 GMT

Hi,

Did you check my suggestion?

Regards

ASHFAQ

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 16:38:21 GMT

hmm I agree with Peter Cammaert then, have a look at your section access. Remember that by default the ACCESS field in section access is set to 'user' in the AP, even though you may specify admin. You'll only be admin on the desktop, so data reduction may still happen to you if the security rights are not set up correctly.

As a test disable the section access and give that a compare between desktop and AP

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 16:46:39 GMT

Hi ASHFAQ

Yes I did

Hi Joe

Yes Peter Cammaert suggestion proved helpful, I disabled the section access and it worked.

Thanks a lot you all

Re: Same App has value differences when opened in AP and Client...

jaimeaguilar — Tue, 28 Oct 2014 16:58:44 GMT

Hi,

Have you considered upgrading to 11.2? There's been improvements regarding how shared files are handled by QV, so it may help with your issue,

regards

Re: Same App has value differences when opened in AP and Client...

Tue, 28 Oct 2014 16:59:22 GMT

That's good maybe have a read of this thread

http://community.qlik.com/docs/DOC-1853

I think what you have done is not specify all possible values in your section access reduction field so the '*' you have given yourself is only for those values.

eg Region as reduction field has UK,USA,FRA,NZL as possible values.

In your section access you have listed 3 users, 1 with UK, 1 with USA, 1 with FRA and then set yourself as *.

The * will only give you those 3 values (UK,USA,FRA), and not to NZL. The * within section access means, all listed values, not all possible values.

Hope that helps

Joe