Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

liamlucas
New Contributor

Prevent Customer from Load in Data Load Script

I want to block the customer named “Extrawagens” from being loaded in the Data Load Script below.  Can you tell me how to do it?

LOAD

    Customer,

    "Sum(Sales)"

FROM [lib://2017Sales/Sales.xlsx]

(ooxml, embedded labels, table is Sales);

  

CustomerSum(Sales)
Grunewald$201,320
Th Fashing$152,115
Champes$91,362
The Corner Store$82,520
Eintrach GS$75,154
Don Balón$68,266
Warp AG$65,816
Vite$59,977
Boombastic$50,922
Roba di Piel$49,783
Extrawagens$45,274
Bond Ltd$41,087
Urras Shop$39,839
Gluderstedt$36,098
Noch Einmal GMBH$35,526
Halle Köln$33,365
Menàge à Trois$27,641
El Zapato Rojo$27,576
Nirvana Stores$22,722
El Carnevale$22,545
Design$21,565
Davenport Fashion$21,133
Millenium$20,822
Los Vatos Locos$19,683
El Pirata$18,636
Paintho da Gama$15,099
Casual Clothing$14,510
Sunny Ski Store$14,331
Los Trajes de Matador$13,307
Big Foot Shoes$11,413
Golden Design Group$11,397
Fritid AB$10,795
Cloe do Pau$10,325
Le Sais de Rión$10,003
La Boheme$9,455
Las Corbatas$9,374
Merced do Vaile$9,211
Ski Store$9,194
Art et Fashion$9,081
Belgium Black Jeans$9,041
La Ropa Vieja$8,985
La Moda Pasada$8,786
Copacabana$8,708
La Moda d'il Futuri$8,334
Too Hot 4U$7,907
La Roba do Santho$7,893
Macalena$7,308
Los Espandrilos Fantasticos$6,923
Dr Jims Trousers$6,688
Stephanies$6,528
El Traige do Benfica$6,337
Perkii Urkii$6,015
De la Vita$4,912
Slotzy Danz$3,977
Autokleider$3,912
La Legion Mercenaire$3,476
Da Bikini Expertu$3,171
X-Site$3,049
King Size Clothes$2,904
Man Kleider$2,643
Shoe Expert$2,574
El Chandal del Barca$2,568
Bobby Socks$2,458
Eye Fashion$2,415
El Abrigo Mortal$2,364
Los Pantalones Magicos$2,317
Sport Shop$2,125
La Moda Alucinante$1,770
Il Pantaloni di la Cammorra$1,746
Fast Sunglasses$1,700
Aujourd´hui$1,533
Tendha do Flamengo$1,495
Das Alpen Shoe$1,458
La Camisas Cansadas$1,442
TTT-The Ticky Tie$1,163
Ropa total$1,113
La Tienda de la Esquina$1,016
The sharped dressed man$883
Chateau de Ville$743
Pour l´homme$707
SSS-Sport Shoes Store$553
Pulp Toxedos$537
Leningrad Cowboys Shop$443
Kohl Industries AG$287
For The Dark Night$264
Fawtly Towers$237
Alles Lusekofter$193
Los Sombreros Gigantes$106
Da Santho Cosmethia$66
1 Solution

Accepted Solutions
MVP
MVP

Re: Prevent Customer from Load in Data Load Script

Like this

LOAD

    Customer,

    "Sum(Sales)"

FROM [lib://2017Sales/Sales.xlsx]

(ooxml, embedded labels, table is Sales)

Where not Match(Customer, 'Extrawagens') ;

1 Reply
MVP
MVP

Re: Prevent Customer from Load in Data Load Script

Like this

LOAD

    Customer,

    "Sum(Sales)"

FROM [lib://2017Sales/Sales.xlsx]

(ooxml, embedded labels, table is Sales)

Where not Match(Customer, 'Extrawagens') ;

Community Browser