Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
john_wilson
New Contributor II

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?

Tags (3)
1 Solution

Accepted Solutions
jchoucq
Contributor II

Re: Difference of Data from point of reload finish and reopening

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

2 Replies
jchoucq
Contributor II

Re: Difference of Data from point of reload finish and reopening

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

john_wilson
New Contributor II

Re: Difference of Data from point of reload finish and reopening

Johann,

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

Thanks again.

John

Community Browser