Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Difference of Data from point of reload finish and reopening

I've come up against an issue with our reporting that I've not experienced in QlikView before - in that I perform a reload of my financial reporting document and before saving and distributing; I take a slice of the data and compare those figures to the document once it has been saved and reopened and am finding a difference in those cross sections.

The document is used by Publisher to distribute the documents with section access - and the account to test this is the administrator account and has been granted global * access.

All selections are clear before drilling down for the slice of data being examined and all other obvious causes.

Has anyone any thoughts on what could cause such a difference?

1 Solution

Accepted Solutions
jchoucq
Partner - Creator III
Partner - Creator III

Hi,

I will try to give you an example.

here are some datas :

LOAD * INLINE [

    F1

    A

    B

    C

];

Here is the Section Access

Section Access;

LOAD * INLINE [

    ACCESS, USERID, F1

    ADMIN, USER1, A

    ADMIN, USER2, B

    ADMIN, USER3, *

];

Section Application;

In fact, User3 will be able to see A and B but not C, because the star (*) refers to the data in the section access and not in the whole model ...

Do you undertstand what i mean ?

Hope this helps

Johann

View solution in original post

2 Replies
jchoucq
Partner - Creator III
Partner - Creator III

Hi,

I will try to give you an example.

here are some datas :

LOAD * INLINE [

    F1

    A

    B

    C

];

Here is the Section Access

Section Access;

LOAD * INLINE [

    ACCESS, USERID, F1

    ADMIN, USER1, A

    ADMIN, USER2, B

    ADMIN, USER3, *

];

Section Application;

In fact, User3 will be able to see A and B but not C, because the star (*) refers to the data in the section access and not in the whole model ...

Do you undertstand what i mean ?

Hope this helps

Johann

Anonymous
Not applicable
Author

Johann,

Yes that makes perfect sense - thank you and I know just where the problem is now.

Thanks again.

John