RE:Section in Qliksene

[Chanty4u]

Hi all,

eightieschild

Toni Kautto

arul settu

Rohit Kumar

Miguel Braga

Michael Tarallo

i have two fileds F1 and F2

F1,F2

Cellphone; private

landline ;pubic

iphone ;both

Section;

access; userd ;F1 ;F2

admin ; chanty;cellphone,private

admin;chanty ;landline;public

admin;chanty;iphone;both

so when i do this   in front end   filters giving F1 anf F2  3 values for each filed.

Now user want that  When he click on F1 value- CellPhone   in F2 Field show only  Private

F1Value -Landline   in F2 vlues should show ony Public lik that user need.

how to implement this?

[MK9885]

Section Access;

Load * Inline [

F1,F2

Cellphone; private

landline ;pubic

iphone ;both

];

Load * Inline

access; userd ;F1 ;F2

admin ; chanty;cellphone,private

admin;chanty ;landline;public

admin;chanty;iphone;both;

SECTION Application;

or

Section Access;

Users:

Load

F1,F2

Cellphone; private

landline ;pubic

iphone ;both

FROM

....................;

Load * Inline

access; userd ;F1 ;F2

admin ; chanty;cellphone,private

admin;chanty ;landline;public

admin;chanty;iphone;both;

SECTION Application;

Also check https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/Security/SectionsInTheScript....

And I guess Section Access will only work on Qlik Sense Server, not on desktop version.

[rittermd]

Section Access will not work with Desktop

[Chanty4u]

yes am implementing in QS server only

[Chanty4u]

yes  arvind654  the script i have implemented the same.

but my issue is:

the result for above script is:

F1  and F2  as filters 

F1;     F2

Cellphone; private

landline ;pubic

iphone ;both

in this Only one user is login so for this it will show  all the field values to this user.

but my requirment is  If i clik  Cellphone - i will show only private   lik dat

[MK9885]

I guess you need to do Initial Data Reduction like we do in Qlik View

Check these links

Section Access: Strict Exclusion

and

https://help.qlik.com/en-US/sense/2.1/Subsystems/Hub/Content/Scripting/Security/dynamic-data-reducti...

[ToniKautto · Accepted solution]

Section access reduces data prior to opening the app. This would not allow the user to toggle between different values, since some values have already been reduced.

I am not sure of what use case you have in mind for this scenario, but the only way to limit display values in a filter pane for example s to apply a calculated dimension. See attached sample for an example.

[Chanty4u]

Nice   its simple and meaningful bro  . let me check with my original data and come back to you/