Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Filter Table based on a fields sub value.

Hi

I have a table which I want to filter the information based on a field it has.

Table1:

field,

field,

field,

Assignee, <--Field I want to filter by but it has 5 different rows, ex. A,B,C... I only want to filter by B.

From

[..\..\02_QVDs\IT\][qvd]; < can I put a where clause here to filter by Assignee but its sub row 'B'?

Tags (4)
1 Solution

Accepted Solutions
MVP
MVP

Re: Filter Table based on a fields sub value.

Hi,

Try like this

LOAD

*

FROM DataSource.qvd (qvd)

WHERE Assignee = 'B';

If it is not working then attach some sample values.

Regards,

Jagan.

1 Reply
MVP
MVP

Re: Filter Table based on a fields sub value.

Hi,

Try like this

LOAD

*

FROM DataSource.qvd (qvd)

WHERE Assignee = 'B';

If it is not working then attach some sample values.

Regards,

Jagan.

Community Browser