topic Re: Section access on multiple feilds in QlikView

Section access on multiple feilds

sujit_nath — Sat, 16 Nov 2024 01:03:13 GMT

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?

Re: Section access on multiple feilds

joseph_morales — Sun, 15 Mar 2020 21:08:45 GMT

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];

Re: Section access on multiple feilds

sujit_nath — Mon, 16 Mar 2020 04:25:56 GMT

Hi Joseph,

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

Re: Section access on multiple feilds

Brett_Bleess — Wed, 08 Apr 2020 18:35:20 GMT

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