Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator II
Creator II

Data reduce in Section Action

HI Community,

I have to reduce data using section action.

this is my section action file,... sheet wise everyone full action,

NTNAMEACCESSCLIENT
US\Av6*Ashok Kumar
US\CharyN*Narasimha Chary
US\Sam1*Sampath

when CLIENT login to application, only they have to see their subclients,  Suppose Ashok Kumar logins to application he have to see his SubClients. it should be first 4 records.

Table:

CLIENTSubClientAmount
Ashok KumarNokia12500
Ashok KumarNokia2520
Ashok KumarNokia3680
Ashok KumarNokia41200
Narasimha CharySamsung18900
Narasimha Charysamsung29000
Narasimha Charysamsung312000
SampathLG18000
SampathLG22900
SampathLG35600

Thanks in Advance..

3 Replies
devarasu07
Master II
Master II

Hi,

Please refer to the attached sample app, actually you no need to keep user information fact table. In general it should work by defining it at section access level. Thanks

ACCESSUSERIDPASSWORDCLIENT
USERUSERUSER*
ADMINADMINADMIN*
USERASHOKASHOKNOKIA1
USERASHOKASHOKNOKIA2
USERASHOKASHOKNOKIA3
USERASHOKASHOKNOKIA4
USERNARASIMHANARASIMHASAMSUNG1
USERNARASIMHANARASIMHASAMSUNG2
USERNARASIMHANARASIMHASAMSUNG3
USERSAMPATHSAMPATHLG1
USERSAMPATHSAMPATHLG2
USERSAMPATHSAMPATHLG3

also remember to do below steps

1) Section access script always keep in the very first tab

2) Define Section Access on document level  “Settings” -> “Document Properties” -> “Opening”

“Initial Data Reduction Based on Section Access”

Tick the checkbox to enable section access in the document.

3) “Settings” -> “Document Properties” ->"Security --> please un check - reload & check override admin security option (its safe side keep admin full permission and it's used to troubleshoot the application if anything goes wrong)

4) try to make backup of you application before doing any changes on section (once it's lost its difficult to recover it)

5) also if you make any changes on the document (Section access), it will reflect after re-open the document

FYI, step 2 & 3

Section.png

also you can check

Section Access

Introduction to Section Access

balar025
Creator III
Creator III

Hi Paul,

First Step: should be your service should be added in section access with ACCESS type ADMIN

Like,

Star is *;

NTNAME     ACCESS     CLIENT

ServiceId     ADMIN          *

YourId          ADMIN          *

A1               USER            A11

B1               USER            B11

C1               USER            C11



Second Step: Prepare your bridge table with client and subclient relation


CLIENTSubClientAmount
A11Nokia12500
A11Nokia2520
A11Nokia3680
A11Nokia41200
B11Samsung18900
B11samsung29000
B11samsung312000
C11LG18000
C11LG22900
C11LG35600


Third Step: Check option inside your qvw. Document Properties - > Opening -> Initial Data Reduction and Strict Exclusion


Thanks

Ravi Balar