topic Re: remove values from filter in QlikView

remove values from filter

Anonymous — Fri, 23 Oct 2015 16:15:38 GMT

I have a filter site thant conatains

100

102

I need to remove in some sheets values 100 and 102

How to do it ?

miguelbraga — Fri, 23 Oct 2015 16:29:16 GMT

Can you please elaborate better your question. I think I didn't understood correctly.

Regards, MB

Fri, 23 Oct 2015 18:38:15 GMT

Try using a "WHERE" Clause to remove rows that contain unwanted values.

i.e.

LOAD *

FROM [Data]

WHERE not MATCH([Value],'100','102') ;

Anonymous — Fri, 23 Oct 2015 18:49:25 GMT

If i understood correctly,add a calculative dimension like mentioned below;

if(Filter site <>100 or Filter site <>102,Filter site)

Hope this helpful

Regards,

Imran K