topic Re: Create new table from two filter-tables in QlikView

Create new table from two filter-tables

Anonymous — Tue, 22 Nov 2016 08:54:40 GMT

Hello,

data are loaded with a normal Load script. Now I would like to set two filters on the loaded data and write “class” in a new field. Two filter tables should be composed to a new table. Unfortunately, do I receive double records in new table?

Thanks for your help

DB:
Load * Inline [
name, baseSite, class, l1, cost,
car, SUP,      BS,     2,   78.482,
car, SUP,      BU,     1,   84.082,
car, SUP,      BU,    '-', 84.082,
car, SUP,      Site,   0,   78.482,
car, HQ,       BS,     2,   1.782.336,
];

Filter1:
Load class as new_class
Resident DB
Where class = 'BU';

Filter1:
Load class as new_class
Resident DB
Where class = 'BS

Re: Create new table from two filter-tables

lironbaram — Tue, 22 Nov 2016 09:02:21 GMT

have a look at the attach example

the problem with your script was that there wasn't any connection between the new field and the records.

this cause the rows to be multiply.

Re: Create new table from two filter-tables

giakoum — Tue, 22 Nov 2016 09:03:32 GMT

use load distinct

Re: Create new table from two filter-tables

Anonymous — Tue, 22 Nov 2016 09:03:51 GMT

By filter do you mean a flag? that will allow you to select all class = BU values or class = BS? Or do you want them to be a separate table that allows you to filter for those two values only?

Re: Create new table from two filter-tables

Anonymous — Tue, 22 Nov 2016 09:11:07 GMT

Many thanks. Only BS and BU should be show in table.

Re: Create new table from two filter-tables

Anonymous — Tue, 22 Nov 2016 09:14:06 GMT

Filter1:
Load class
Resident DB
Where Match(class,'BU','BS');

Do not rename class as new class as it will not be able to filter your main table.

Re: Create new table from two filter-tables

Anonymous — Tue, 22 Nov 2016 09:27:01 GMT

Can you show me both solutions, pls.

Re: Create new table from two filter-tables

hemanthaanichet — Tue, 22 Nov 2016 09:36:42 GMT

Hi Stefan,

I think there is some issue in your script

i tired in three different ways.

May this may help u i think

have a look at my attachment

Regards

Hemanth

Re: Create new table from two filter-tables

Anonymous — Tue, 22 Nov 2016 09:43:41 GMT

Many thanks, Stefan

Re: Create new table from two filter-tables

hemanthaanichet — Tue, 22 Nov 2016 09:52:01 GMT

always Welcome Stefan Cheers...:)