Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

omit 3rd column section access

Hiya

i have seen two posts from hic

i have used the following similar content like this in an app, first post from hic

Load Region &'|'& Product as AuthID, Region &'|'& Product as %AuthID  From OrderDetails ;

     Load Region &'|'& Product as AuthID, Region &'|'&'<ANY>' as %AuthID  From OrderDetails ;

     Load Region &'|'& Product as AuthID, '<ANY>'&'|'& Product as %AuthID  From OrderDetails ;

     Load Region &'|'& Product as AuthID, '<ANY>'&'|'&'<ANY>' as %AuthID  From OrderDetails ;


second post from hic 

Data Reduction Using Multiple Fields

issue i have is this is for section access relating to two columns of data...Region and Product...

i for example need to restrict on columns Region and Product...and CompanyName..

how is this achievable?

please help...


1 Solution

Accepted Solutions
ogster1974
Master II
Master II

By extending your cases to include CompanyName. e.g.

Load Region &'|'& Product &'|'& CompanyName as AuthID, Region &'|'& Product &'|'& CompanyName as %AuthID  From OrderDetails ;

......

Although you might be able to get away without using Region if you are now using CompanyName as a security identifier if a Company belongs to a Region.

Regards

Andy

View solution in original post

2 Replies
ogster1974
Master II
Master II

By extending your cases to include CompanyName. e.g.

Load Region &'|'& Product &'|'& CompanyName as AuthID, Region &'|'& Product &'|'& CompanyName as %AuthID  From OrderDetails ;

......

Although you might be able to get away without using Region if you are now using CompanyName as a security identifier if a Company belongs to a Region.

Regards

Andy

joeybird
Creator III
Creator III
Author

Hiya

Brill thank you worked really well

Kind Regards