Section access on multiple feilds

[sujit_nath]

I have data such as (Dummy data)

LOAD * INLINE [

Country, City, Company

Argentina, Buenos Aires, Los Espandrilos Fantasticos

Austria, Graz, Ski Store

Belgium, Bruxelles, De la Vita

Brazil, Campinas, Paintho da Gama

Brazil, Rio de Janeiro, Da Bikini Expertu

Brazil, São Paulo, Roba di Piel

Brazil, São Paulo, Tendha do Flamengo

Canada, Tsawassen, Big Foot Shoes

France, Nantes, Le Sais de Rión

France, Paris, Chateau de Ville

Germany, Stuttgart, Autokleider

Ireland, Cork, Boleros

Mexico, México D.F., Don Balón

Mexico, México D.F., Los Sombreros Gigantes

Portugal, Lisboa, El Traige do Benfica

Portugal, Lisboa, La Roba do Santho

Spain, Barcelona, El Chandal del Barca

Spain, Madrid, Las Corbatas

Spain, Sevilla, Los Trajes de Matador

Sweden, Stockholm, Stephanies ];

Section access Script as :-------------------------------

Section Access;

LOAD * INLINE [

  ACCESS, USERID, PASSWORD, LINK

  ADMIN, Frank, password, *

  USER, John, jonhpwd, 1

  USER, Mary, marypwd, 2

];

Section Application;

LOAD * INLINE [

   LINK, Country

  1, Spain

  1, Mexico

  2, France

  3, Brazil

  3, Austria ];

Here I have reduction on Country. How do I apply reduction on 2 feilds? Like Country and City?

John should see Spain and all cities in Spain

Mary should see Brazil and Bruxelles.

How do I do that?

[joseph_morales]

Hi @sujit_nath,

You can try with this:

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, COUNTRY_SA, CITY_SA
ADMIN, Frank, password, *, *
USER, John, jonhpwd, Spain, *
USER, Mary, marypwd, Brazil, *
USER, Mary, marypwd, Belgium, Bruxelles
USER, DUMMY, DUMMY, Argentina, Buenos Aires
USER, DUMMY, DUMMY, Austria, Graz
USER, DUMMY, DUMMY, Belgium, Bruxelles
USER, DUMMY, DUMMY, Brazil, Campinas
USER, DUMMY, DUMMY, Brazil, Rio de Janeiro
USER, DUMMY, DUMMY, Brazil, São Paulo
USER, DUMMY, DUMMY, Canada, Tsawassen
USER, DUMMY, DUMMY, France, Nantes
USER, DUMMY, DUMMY, France, Paris
USER, DUMMY, DUMMY, Germany, Stuttgart
USER, DUMMY, DUMMY, Ireland, Cork
USER, DUMMY, DUMMY, Mexico, México D.F.
USER, DUMMY, DUMMY, Portugal, Lisboa
USER, DUMMY, DUMMY, Spain, Barcelona
USER, DUMMY, DUMMY, Spain, Madrid
USER, DUMMY, DUMMY, Spain, Sevilla
USER, DUMMY, DUMMY, Sweden, Stockholm
];

Section Application;

DATA:
LOAD *, 
UPPER(Country)	AS COUNTRY_SA,
UPPER(City)		AS CITY_SA;
LOAD * INLINE [
Country, City, Company
Argentina, Buenos Aires, Los Espandrilos Fantasticos
Austria, Graz, Ski Store
Belgium, Bruxelles, De la Vita
Brazil, Campinas, Paintho da Gama
Brazil, Rio de Janeiro, Da Bikini Expertu
Brazil, São Paulo, Roba di Piel
Brazil, São Paulo, Tendha do Flamengo
Canada, Tsawassen, Big Foot Shoes
France, Nantes, Le Sais de Rión
France, Paris, Chateau de Ville
Germany, Stuttgart, Autokleider
Ireland, Cork, Boleros
Mexico, México D.F., Don Balón
Mexico, México D.F., Los Sombreros Gigantes
Portugal, Lisboa, El Traige do Benfica
Portugal, Lisboa, La Roba do Santho
Spain, Barcelona, El Chandal del Barca
Spain, Madrid, Las Corbatas
Spain, Sevilla, Los Trajes de Matador
Sweden, Stockholm, Stephanies];

[sujit_nath]

Hi Joseph, 

This solution would be real difficult in big sized data. Isn't there an easier way to acheive this?

[Brett_Bleess · Accepted solution]

Have a look at the following Design Blog post, hopefully that is what you needed:

https://community.qlik.com/t5/Qlik-Design-Blog/Data-Reduction-Using-Multiple-Fields/ba-p/1474917

Regards,
Brett