Discussion Board for collaboration related to QlikView App Development.
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?
load * inline
load Status as stat,
Value as val
drop table t1;
or if you are loading data from table
(ooxml, embedded labels, table is Tab1)