topic Re: Exclude certain conditions in QlikView

Exclude certain conditions

Mon, 10 Jun 2013 13:01:49 GMT

Hi,

I have a source file, field formats as below:

ID	Time	FieldA	FieldB	FieldC
1	8:00
2	8:00
3	8:00
4	8:00
5	8:00
6	8:00
7	8:00
8	8:00
9	8:00
10	8:00
11	8:00
12	8:00
13	8:00
14	8:00

I would like to exclude the following IDs and time from the source

ID	Time	Condition
1	8:00	TRUE
2	9:00	TRUE
3	8:00	TRUE
1	9:00	TRUE
2	10:00	TRUE
1	10:00	TRUE
2	11:00	TRUE
1	11:00	TRUE
2	12:00	TRUE
3	9:00	TRUE
4	8:00	TRUE
5	9:00	TRUE
6	10:00	TRUE
4	9:00	TRUE

How can I do that? the time and ID are generic, basically, each person will have time ranging from 08:00 to 20:00.

Hope you could help to provide the answer in words as i cannot open other's qvw file...

thanks!

Re: Exclude certain conditions

tresB — Mon, 10 Jun 2013 13:29:12 GMT

Are these conditions discrete? can't you generalize it? To exclude them during load you have to use WHERE clause. But using them with OR would make it explicit/hard coded, not sure if your requirement demands so or not.

Thanks.

Re: Exclude certain conditions

swuehl — Mon, 10 Jun 2013 13:36:07 GMT

You can possibly create a composite key made of ID and Time, then load your exclusion table first and use

...

where not exists(Key);

when loading your main table.

Re: Exclude certain conditions

Tue, 11 Jun 2013 00:34:30 GMT

Hi,

THanks. This condition is discrete. If i would like to exclude them in the load condition, how can i do that?