Weird behavior of QVW

[#1]

Hi All,

I have QVW file on server, When i open and reload it will show some value. After saving and reopening again it shows some other data. Dunno from where tat data is coming.

In the local its proper

Please help me with this.

Regards,

Keerthi KS

[#2]

Now data is visible to all users. 

Actually data is not showing even for administrator because of those selections

[jagan]

Hi,

Revert back the changes and Instead of ALL replace *, this will work as expected.

* means display all.

Hope this helps you.

Regards,

jagan.

[#4]

I have already reverted the changes. I will try with this.

[qlikviewwizard]

When you remove the security, check the tab properties, sheet properties if security was implemented.

Once you remove the security, you have to reload it.

[#6]

Hi Jagan,

I have changed ALL to * in section access and also in the excel. Still the data is reducing.

Any other way to do it ?

Regards,

Keerthi KS

[jagan]

Hi,

Check this link it is working as expected in that and compare it with your code.

Authentication and Authorization in Qlikview

Regards,

jagan.

[#8]

Hi Jagan,

I have changed the code but still there is data reduction.

Below is the code and attached  the  excel that i am using.

Section Access;

ACCESS:

LOAD * INLINE [

    ACCESS, NTNAME, PROJECTID, ROLL

    ADMIN, FUGUEDB\ADMINISTRATOR, 53, *

    ADMIN, QlikView1\Administrator, *, *

    ADMIN, TEBS\sivannagari.roopa, *, *

];

Concatenate(ACCESS)

LOAD 'USER' as ACCESS,

  ADNAME as NTNAME,

    if(Len(trim(PROJECTID))=0,'*',PROJECTID) as PROJECTID,

    ROLL

FROM

[..\..\00_includes\config\Access.xlsx]

(ooxml, embedded labels, table is Access) Where Len(Trim(ADNAME))<>0;

Concatenate(ACCESS)

LOAD Distinct

    'ADMIN' as ACCESS,

  'FUGUEDB\ADMINISTRATOR' as NTNAME,

    PROJECTID as PROJECTID,

    '*' as ROLL

Resident Projects;

Concatenate(ACCESS)

LOAD Distinct ACCESS,NTNAME,'OTHERS' as PROJECTID,ROLL Resident ACCESS;

Section Application;

Star is *;

ROLL:

LOAD ROLL,

    SH_Inventory,

    SH_Sales,

    SH_Receivable,

    SH_Cashflow,

    SH_Marketing

FROM

[..\..\00_includes\config\Access.xlsx]

(ooxml, embedded labels, table is ROLLs);

Regards,

Keerthi KS

[jagan]

Hi,

On what basis you are reducing the data based on ProjectID or Roll?  There is no ProjectID  in Section Application.

Regards,

Jagan.

[#10]

Based on the Roll and also checking for ProjectID.

[jagan]

Hi,

There is no Project ID in your script after the section access?  Did you missed any script?  Check this links

Re: section access - multi-field data reduction

Re: Re: Section Access with Multiple Entries and Multiple Fields

Regards,

Jagan.