Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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?
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.
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;
And I guess Section Access will only work on Qlik Sense Server, not on desktop version.
Section Access will not work with Desktop
yes am implementing in QS server only
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
I guess you need to do Initial Data Reduction like we do in Qlik View
Check these links
Section Access: Strict Exclusion
and
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.
Nice its simple and meaningful bro . let me check with my original data and come back to you/