topic Re: How to filter multiple columns in single QVD. in QlikView

How to filter multiple columns in single QVD.

vinod2086 — Fri, 12 Dec 2014 11:08:37 GMT

Hi Friends,

I have a table(Test) contains 6 columns

ID	NAME	OWNER	OWNER_A	OWNER_B	CITY
1	RRR	HCL	Customer_TCS	others	HYD
2	AAA	Customer_HCL	TCS	HCL	BANGALORE
3	CCC	TCS	others	Customer_TCS	MUMBAI
4	DDD	Customer_TCS	Customer_HCL	Customer_TCS	HYD
5	RRR	others	HCL	TCS	BANGALORE
6	AAA	Customer_HCL	Customer_TCS	others	MUMBAI
7	CCC	Customer_HCL	TCS	HCL	HYD
8	DDD	HCL	others	Customer_TCS	BANGALORE
9	RRR	TCS	Customer_HCL	Customer_TCS	MUMBAI
10	DDD	Customer_TCS	HCL	TCS	PUNE

AND HERE THE PROBLEM IS I WANT TO APPLY CONDITION IN TWO WAYS.

1) i want to display HLC AND Customer_HCL data in OWNER.OWNER_A AND OWNER_B

2) I dont want to display "others" in 3 columns(OWNER.OWNER_A AND OWNER_B).

pls help me how to apply.

yduval75 — Fri, 12 Dec 2014 11:13:19 GMT

LOAD

ID,

NAME,

OWNER,

OWNER_A,

OWNER_B,

CITY

From table_test

where

match(OWNER_A, 'HCL', 'Customer_HCL', 'others') > 0

or match(OWNER_B, 'HCL', 'Customer_HCL', 'others') > 0

or match(OWNER, 'others') > 0

;

its_anandrjs — Fri, 12 Dec 2014 13:05:21 GMT

Hi,

Try this for only HCL, Customer_HCL data

Tab1:

LOAD

ID, NAME, OWNER, OWNER_A, OWNER_B, CITY

From Location

Where

Match(OWNER,'HCL','Customer_TCS')

or Match(OWNER_A,'HCL','Customer_TCS')

or Match(OWNER_B,'HCL','Customer_TCS');

Regards

Anand

fsimoes81 — Fri, 12 Dec 2014 13:17:09 GMT

The Match function and your family, mixmatch and wildmatch are very functional.