topic Re: Excluding a value from a table in QlikView

Excluding a value from a table

Anonymous — Wed, 01 Apr 2015 23:05:03 GMT

Hello,

I'm loading a table called status, which contains the values: Sold, In Stock, Reserved, Unknown.

I'm wondering if it's somehow possible to exclude the value 'Unknown' from the load so that for all graphs, charts or filters I have the value is not even listed.

Can someone help me here?

Cheers

spijatida

Re: Excluding a value from a table

robert_mika — Wed, 01 Apr 2015 23:16:17 GMT

use where

t1:

load * inline

[Status,Value

Sold, 20

In Stock,30

Reserved,30

Unknown,20

];

t2:

load Status as stat,

Value as val

resident t1

where Status<>'Unknown';

drop table t1;

or if you are loading data from table

Directory;

LOAD Status,

Value

FROM

Book2.xlsx

(ooxml, embedded labels, table is Tab1)

where Status<>'Unknown';