topic Re: Data reduce in Section Action in QlikView

Data reduce in Section Action

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

HI Community,

I have to reduce data using section action.

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

NTNAME	ACCESS	CLIENT
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:

CLIENT	SubClient	Amount
Ashok Kumar	Nokia1	2500
Ashok Kumar	Nokia2	520
Ashok Kumar	Nokia3	680
Ashok Kumar	Nokia4	1200
Narasimha Chary	Samsung1	8900
Narasimha Chary	samsung2	9000
Narasimha Chary	samsung3	12000
Sampath	LG1	8000
Sampath	LG2	2900
Sampath	LG3	5600

Thanks in Advance..

Re: Data reduce in Section Action

prma7799 — Wed, 28 Jun 2017 05:10:05 GMT

Please check this

Section Access - Reducing Data + Using "OMIT" i... | Qlik Community

Section access and data reduction - ADMIN user ... | Qlik Community

Re: Data reduce in Section Action

devarasu07 — Wed, 28 Jun 2017 05:17:20 GMT

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

ACCESS	USERID	PASSWORD	CLIENT
USER	USER	USER	*
ADMIN	ADMIN	ADMIN	*
USER	ASHOK	ASHOK	NOKIA1
USER	ASHOK	ASHOK	NOKIA2
USER	ASHOK	ASHOK	NOKIA3
USER	ASHOK	ASHOK	NOKIA4
USER	NARASIMHA	NARASIMHA	SAMSUNG1
USER	NARASIMHA	NARASIMHA	SAMSUNG2
USER	NARASIMHA	NARASIMHA	SAMSUNG3
USER	SAMPATH	SAMPATH	LG1
USER	SAMPATH	SAMPATH	LG2
USER	SAMPATH	SAMPATH	LG3

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

also you can check

Section Access

Introduction to Section Access

Re: Data reduce in Section Action

balar025 — Wed, 28 Jun 2017 05:38:59 GMT

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

CLIENT	SubClient	Amount
A11	Nokia1	2500
A11	Nokia2	520
A11	Nokia3	680
A11	Nokia4	1200
B11	Samsung1	8900
B11	samsung2	9000
B11	samsung3	12000
C11	LG1	8000
C11	LG2	2900
C11	LG3	5600

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

Thanks

Ravi Balar