Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
stig1984
Contributor

Data in portal differs to desktop

Hi,

Hoping you can help with something which is driving me to distraction.

I have a data difference between an app as viewed in the portal and the exact same app in the same environment when opened in desktop.

In one app I have a particular field which does not contain any data when viewed via the portal, meaning that an expression is returning the wrong result.  When the same app is opened in the desktop and reloaded from exactly the same datasource (a qvd file previously generated which contains multiple rows of data) the data is correct and the expression works. 

I have a similar issue in a seperate app (same scenario).

Any ideas for things to look for?

Operating on Qlikview Nov 2017 SR 7 12.20.2080

Labels (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Data in portal differs to desktop

It sounds like you have a Section Access table in the script with an OMIT that is effective when you are on the server. 

 

-Rob

4 Replies
MVP & Luminary
MVP & Luminary

Re: Data in portal differs to desktop

It sounds like you have a Section Access table in the script with an OMIT that is effective when you are on the server. 

 

-Rob

stig1984
Contributor

Re: Data in portal differs to desktop

Thanks - why just one field though?

The field with the changing data shouldn't be affected by the section access.

stig1984
Contributor

Re: Data in portal differs to desktop

Sorry - neglected to mention that not all of the data is necessarily omitted.

I have re-saved the app with the Data reduction based on section access turned off - no change in end result.

stig1984
Contributor

Re: Data in portal differs to desktop

Definitely related to section access somehow as when this is turned off the data comes through.  Strange though as the field affected is not related to section access at all.

Just need to find a solution now to work with section access active.