topic Re: HOW TO CREATE SECTION ACCESS? in QlikView

HOW TO CREATE SECTION ACCESS?

Sun, 17 May 2015 09:57:33 GMT

HI,

I CREATED SECTION ACCESS LIKE THIS AFTER I SELECT INTIAL DATA REDUCTION BASED ON SECTION ACCESS CHECKBOX. AND PROHIBIT BINARY LOAD CHECK BOX. THE PROBLEM IS WHEN I ENTER MY USERNAME PASSWORD IT SHOW USER DETAILS AT THE SAME TIME ENTER ADMIN USERNAME AND PASSWORD BUT IT SHOW ONLY ONE USER RECORDS.I WANT TO DISPLAY DATA LIKE THIS .IF I ENTER USER NAME AND PASSWORD IT SHOW ONLY USER DETAILS

.IF I ENTER ADMIN USER NAME AND PASSWORD THE APPLICATION SHOW ALL RECORDS.BUT I DO NOT KNOW HOW TO DO IT . PLS TELL ME OUT HOW TO DISPLAY LIKE THIS

.IF I ENTER USER NAME AND PASSWORD IT SHOW ONLY USER DETAILS

.IF I ENTER ADMIN USER NAME AND PASSWORD THE APPLICATION SHOW ALL RECORDS

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER, MSR, MSR

USER, KSR, KSR

];

Section Application;

LOAD *

Inline [

USERID,Product

MSR,LAPTOPS

KSR,TVS

];

THANKYOU,

REGARDS:

MADHU

Re: HOW TO CREATE SECTION ACCESS?

Anonymous — Mon, 18 May 2015 19:19:47 GMT

I wouldn't recommend using resereved field (like USERID in your case) for data reduction. In the following example, I changed USERID to USER_ID in the section application, and added a field specifically for data reduction, called it REDUCTION. Notice that the value of this field for ADMIN is * - that means all listed values.

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, REDUCTION
    ADMIN, ADMIN, ADMIN, *
    USER, MSR, MSR, MSR
    USER, KSR, KSR, KSR
];

Section Application;

LOAD *
Inline [
USER_ID,Product, REDUCTION
MSR,LAPTOPS, MSR
KSR,TVS, KSR
];

Re: HOW TO CREATE SECTION ACCESS?

philipp_ebner — Wed, 20 Jul 2016 13:49:24 GMT

Hi Madhu,

this should work:

Star is *;

Section Access;

LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, MSR, MSR
USER, KSR, KSR
];

Section Application;
LOAD *
inline [
USERID, Product
ADMIN,*
MSR,LAPTOPS
KSR,TVS
];

Regards Philipp