How to filter the data in this scenario.

[Anonymous]

Hi ,

I have a created a pivot table with the required dimensions.

scenario:

If I select the organisation the pivot table should display the 'group name' , 'service type', 'month/year' and the 'value'.

but as you can see in the pic below for every organisation there are service names including 'test team' or 'test service' which is related to the respective 'service id's'

My requirement is the pivot table should only display the  contents of all  the service names except Test Team or Test service into the Group name in pivot table.

I am attaching the pic for your reference.

any help is highly appreicated.

[sunny_talwar]

test team and test service are associated with 2 and 3 service id? If yes, you can do this:

Sum({<service_id -= {2, 3}>} Measure)

or

Sum({<service_name -= {*Test*}>} Measure)

[vishsaggi]

Can you do a restriction on Service name like in your list box expression

[Anonymous]

No They are not associated.

Perhaps i am thinking to use your old where clause to avoid getting from the database into Qlikview.

What do you say? in that case all the service names will be live ones not the test.

[sunny_talwar]

You sure can and should if you don't need the tests

[Anonymous]

ok.

It is throwing error like this.

LOAD id as service_id,

name as "service_name"

Where service_name not in ('Test Team ', 'Test service');

[sunny_talwar]

it seems that the field name is called something else in the raw data. What is it called?

[Anonymous]

it is called name but I am using name as 'service_name'

Does it throw error?

[Anonymous]

It is loading the data without errors but it is not filtering the Test Team or Test Service.

[sunny_talwar]

Because you might need wildcard search using Like and % because the description is not Test Team... it is amsjadhTest Team or something along those lines, right?