Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Need help on SA

Hi all,

@frankhanhart  , @Vegar  @sunny_talwar 

i have  one   filed called  sellername .   in that field i have sellers around 200 members 

so now  i want to  implement section access  based on  seller   

if seller  is   sony     

then  sony login  only sony seller  info only need to see like that .

so which is possible way to do this?  

 

Labels (2)
2 Replies
Vegar
MVP
MVP

Try something like this.

Section Access;
LOAD * INLINE [
    ACCESS, NTNAME, 				SELLERNAME
    ADMIN, 	EXAMPLE\ADMIN,			*
    USER, 	EXAMPLE\VEGAR,			VEGAR
    USER, 	EXAMPLE\FRANKANHART,	FRANKANHART
    USER, 	EXAMPLE\SUNNYTALWAR,    SUNNYTALWAR
    USER, 	EXAMPLE\SONIASWEETY, 	SONIASWEETY   
];

Section Application;
DATA:
LOAD 
  UPPER(Sellername) as SA_SELLERNAME,
  Sellername,
  SalesAmount,
  SalesQty
FROM 
  EXCEL;
Brett_Bleess
Former Employee
Former Employee

Here is a Design Blog post in addition to what Vegar gave you, but if Vegar's post got you what you needed, be sure to thank him by clicking the Accept as Solution button on his post.  If that did not quite work, have a look at the following post, there are two dynamic data reduction posts at the bottom of this post as well, just FYI, but I wanted to include the base article as well...

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Hopefully this will fill in any gaps you may have.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.