Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

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,

0 Replies