Section Access on two fields

[rsdhavle]

I am implementing section access on two fields. I have one scenario for an example. i am doing section access on Field A  which is Country and Field B which is City

USER      COUNTRY      CITY

A               INDIA           ALL
A                CHINA         BEIJING

I have to give access to user A on all cities from india and only beijing city from China, How to write section access piece for this so that user A gets correct privileges?

[marcus_sommer]

I think this could be helpful: http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields

- Marcus

[maxgro]

you can also expand the values in city field and remove the country

USER     CITY

A               MUMBAI

A               DELHI

A               BANGALORE

A               ......

B               BEIJING