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.
Not applicable

Data Reduction?

Good day all fellow Qlikview developians,

Please assist in any advise as to what is the required procedure to implement data reduction into a dashboard.

I have followed the procedure of section acces as below:

     Section Access;

     LOAD * INLINE

     [

         NTNAME,                                ACCESS,      LOCATION

         DOMAINNAME\NATHAN,         USER,           CAPE TOWN

     ];

     Section Application;

Changed to the document opening properties to 'Initial Data Reduction Based on Section Access'.

After this i've published dashboard on the server and the data doesn't reduce to show only data specific to the LOCATION field.

What am I missing here?

Many Thanks,

Nathan Alard.

Tags (1)
1 Solution

Accepted Solutions
deepakk
Valued Contributor III

Re: Data Reduction?

HI ,

You fieldname LOCATION should be same as the fieldname in the table. Its case sensitive nad hence the location should be in capital at both the places.

You can try out this. Comment the Section Access and Section Application from the code

// Section Access;  comment this line

     LOAD * INLINE

     [

         NTNAME,                                ACCESS,      LOCATION

         DOMAINNAME\NATHAN,         USER,           CAPE TOWN

     ];

   //  Section Application; comment this line

When you load this data the above table should link with your Location master table on the basis of LOCATION only.

Deepak

2 Replies
deepakk
Valued Contributor III

Re: Data Reduction?

HI ,

You fieldname LOCATION should be same as the fieldname in the table. Its case sensitive nad hence the location should be in capital at both the places.

You can try out this. Comment the Section Access and Section Application from the code

// Section Access;  comment this line

     LOAD * INLINE

     [

         NTNAME,                                ACCESS,      LOCATION

         DOMAINNAME\NATHAN,         USER,           CAPE TOWN

     ];

   //  Section Application; comment this line

When you load this data the above table should link with your Location master table on the basis of LOCATION only.

Deepak

Not applicable

Re: Data Reduction?

Thanks Deepak! Works perfectly, the problem was in the case sensitive field relation, and corrected by renaming the field to the same case.

Much Appreciated :-)

Nathan Alard.

Community Browser