Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Chanty4u
Esteemed Contributor III

RE:Section in Qliksene

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?


Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: RE:Section in Qliksene

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.

7 Replies
Khan_Mohammed
Honored Contributor II

Re: RE:Section in Qliksene

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
Honored Contributor

Re: RE:Section in Qliksene

Section Access will not work with Desktop

Chanty4u
Esteemed Contributor III

Re: RE:Section in Qliksene

yes am implementing in QS server only

Chanty4u
Esteemed Contributor III

Re: RE:Section in Qliksene

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

Khan_Mohammed
Honored Contributor II

Re: RE:Section in Qliksene

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...

Employee
Employee

Re: RE:Section in Qliksene

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
Esteemed Contributor III

Re: RE:Section in Qliksene

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

Community Browser