Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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