Qlik Community

Qlik Sense App Development

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

joeybird
Contributor II

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

Re: omit 3rd column section access

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

2 Replies
ogster1974
Honored Contributor II

Re: omit 3rd column section access

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

Re: omit 3rd column section access

Hiya

Brill thank you worked really well

Kind Regards