topic Table Filter Options in QlikView

Table Filter Options

Thu, 18 Mar 2010 08:39:22 GMT

Hello, I'm a Newby so i'm hoping anybody could tell me how too do this..

I've created a table like this:

LOAD*INLINE [
COBRA Table1
Z00001
Z00002
Z00003
ZNIET1
20
Z00004
];

This works fine, but i wonder if there is anyway that i can Filter "20" / "ZNIET1" out of this table. Or to show only the "Z00001" / "Z00002" / "Z00003" / "Z00004" values.

( this is a small example the normal lists contains more rubbish, I'd like to have only the Z00001 / Z00002 / Z00003 / Z00004 values left ).

Thanks!

Mark

Table Filter Options

Thu, 18 Mar 2010 08:46:23 GMT

Useee the power of w�ldmatch .. 🙂

best regards


COBRATable1:
LOAD * WHERE WILDMATCH([COBRA Table1],'Z0*');
LOAD*INLINE [
COBRA Table1
Z00001
Z00002
Z00003
ZNIET1
20
Z00004
];

Table Filter Options

Thu, 18 Mar 2010 08:52:51 GMT

Thanks! Works great!

Table Filter Options

Thu, 18 Mar 2010 08:54:39 GMT

Thanks! Works great!