topic Re: Need help on SA in QlikView

Need help on SA

soniasweety — Sat, 16 Nov 2024 20:06:13 GMT

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?

Re: Need help on SA

Vegar — Tue, 10 Sep 2019 19:34:37 GMT

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;

Re: Need help on SA

Brett_Bleess — Mon, 23 Sep 2019 21:12:46 GMT

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