topic Re: 'Select' ,'Exclude' in multiple fields in QlikView

'Select' ,'Exclude' in multiple fields

Fri, 09 Aug 2013 05:23:51 GMT

Dear All,

I want to exclude multiple values from multiple filelds. But it should done by a single button.

For example,

If i have 3 filelds Named as A,B,C

a)Field A contains: 1,2,3,4,5

I need to exclude "5"

b)Field B contains: A,B,C,D,E

I need to exclude "C"

C)Field C contains: John, Brito, Thomas, Sam, Antony

I need to exclude "Sam"

The final table should be like

(Fields) A B C

1 A John

2 B Brito

Can any one help me please.

Thanks,

Pradeep

Gysbert_Wassenaar — Sat, 10 Aug 2013 17:44:16 GMT

See attached qvw.

Mon, 12 Aug 2013 02:25:21 GMT

Thanks Gysbert!

It work's, if i want to exclude multiple values in a field. Can i use 1|,2|3|

Gysbert_Wassenaar — Mon, 12 Aug 2013 07:58:54 GMT

Yes, change the search string to: (1|2|3)

Mon, 12 Aug 2013 08:09:38 GMT

Very Thanks for your reply!

It's working exactly.