Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
spijatida
Contributor III
Contributor III

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

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