Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
nisha_rai
Contributor

Section Access based on single field with multiple value

Hi,

Please help me to get the solution for the below scenario.

For Eg:

Table1:

Country, Group

UK,ABC

US,XYZ

HK,PQR

US,ABC

HK,ABC

India, XYZ

Table2:

Country, Sales,Item

UK,200,A

US,300,B

India,400,C

HK,500,D

Result:

Apply section Access for a user who belong to group ABC  but his country is US, can able to see the data for UK,US,HKand India at high level but he can able to drill down for US.

I tried to create a excel which is containing multiple rows based on Group and Country but i want all those information in one row  and apply section access on that

For eg. Expected Result:

User , Group, Country1, Country2,country3,country4 and so on

A,ABC,UK,US,HK

What i have:

User,group,country

A ABC Uk

A ABC US .. and so on

Thanks,