Loading from 2 QVDs then exclud some data

[#1]

Hi,

I am loading from two different QVDs.

The first QVD has the calls data such as Number called, duration.. and the second QVD has the Employee information such as Names, Departments..

I have excluded some of the departments as I need to do.

While building a chart to show the total Nr called by Department I have on of the columns in the chart has no Department name.

i know the reason is that I have excluded some of the departments..

How can I hide this column from the chart?

Thanks for your help

[#2]

Under Dimensions select Suppress Null Values

[#3]

That will hide it but the total on the chart doesn't change..it still shows me the total including the hidden departments

[#4]

You can us set analysis to exclude them also:

Count({<Department-={'A','B','C','D','E','F'}>} NrCalled)

[#5]

Do you mean I have to enter the Department names instead of A, B, C..?

I am trying to avoid hard coding department names..

Any other solutions?

Also I tried to see how it works with one department and did: =NUM(Count({<Department-={'DirectSales - Drury'}>} FinalParty),'#,##0')

It gave me a wrong Nr!

Thanks:)

[#6]

In fact this work fine..

But is there anyway where I don't need to hard code the department names.

Thxs

[#7]

Do the departments that you want to exclude have a certian criteria or flag assigned to them?

[#8]

Nope! that would be helpfull though

[#9]

I guess another way would be to change how the QVD files are joined in the script.

[#10]

This sound great..do you know how to use set analysis in the expression edit..

Like I have a drill down chart and the first dimention is month..

I am trying to do the same thing

I tried:

= Only({<Department-={'DirectSales - Drury'}>} Month),'#,##0')

It didn't work!

Thxs