Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Excluding a value from a table

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

1 Reply
robert_mika
Master III
Master III

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