Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Jacob
New Contributor II

Section Access : Combining Field Reduction and OMIT

Hi All

I have below Requirement in section access.

Requirement 

*       i have User1  and User2
      User1 

*       can see 2 countries data out of 15 countries i.e IND and US
*       User1 can see the US of COGS, but cannot see the India COGS
User2

*      Can See all the all data

Please refer below table 

Country 

Country   Product            Regioninfo
INDBOOKEABC
UAEPENWXYZ
USBAGNXYZ
UKPHONECXHD
PAKLONG BOOKEXJZ

 

Sales  

 

COGSSALES
10010
20020
30030
40040
50050

.

Output

When User1 login he should see below table

CountryProductRegion infoCOGSSALES
INDBOOKEABC 10
UAEPENWXYZ20020

 

When User2 login he should see below table

Country ProductRegioninfoCOGSSALES
INDBOOKEABC10010
UAEPENWXYZ20020
USBAGNXYZ30030
UKPHONECXHD40040
PAKLONG BOOKEXJZ50050