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

[manojkulkarni]

Hi,

do you have section access implemented ? If so then it might be filtering data.

[#3]

Yes section access is implemented but its not filtering data. Getting some other data

[Anonymous]

Might be because of Section Access.....Check it once

[#5]

Section Access;

ACCESS:

LOAD * INLINE [

    ACCESS, NTNAME, PROJECTID, ROLL

    ADMIN, FUGUEDB\ADMINISTRATOR, 53, ALL

    ADMIN, QlikView1\Administrator, *, ALL

    ADMIN, TEBS\sivannagari.roopa, *, ALL

];

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,

     'ALL' as ROLL

Resident Projects; 

Concatenate(ACCESS)

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

//FROM

//[..\..\10_data_sources\teproject.qvd]

//(qvd);

Section Application;

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);

This is the code written in Section Access

[jonathandienst]

Section access with data reduction works like this - the reduction only happens when you open the document, so you will see the following:

• Open document - you will see reduced data
• Reload document - when complete, you will see all data (no reduction)
• Close document
• Open document again - you will see reduced data

The data can only "change" at reload - your expressions may be affected by the reduction - so some metrics and KPI values may change, but the data in the source document is the same.

[#7]

Where can i correct this, if data is reducing.

[jagan]

Hi,

If you have section access and when you reload it will show all the values and Reduction is not applied at that moment.  When you close and open the document again it will show the reduction values.

This is all because of Section Access.

Hope this helps you.

Regards,

Jagan.

[#9]

how do i correct this ?

[jagan]

Hi,

You don't need to change anything this is the default behavior of Qlikview, whenever you reload just save, close and open the document again.

Regards,

jagan.