Match function issue

[raju_salmon]

Hi All,

Please find the attached QVW.

I have created "Expanded Sat and Sun Count YearWise" Chart, it should show the count of sat and sun for the each year.

Ex: 2004 - 52+52=104

If i see expanded chart, it is showing 52 Sat and 52 Sun When we collapsed it, it is showing 366.

Because it is also calculating NULL values, which i have suppressed.

Can we exclude NULL values (262) from calculation?

I have created WeekStatus Field using Match Function. Is there any function which i can use here to do not calculate other than SAT and SUN? Please see the script for this field.

I have lot of requirement like this to use Match function to select few values from main field to derive new field, and i need to use those fields in PIVOT table... due to NULL values, i am not getting correct figure while collapsing the pivot table.

Thanks,

Raju

[raju_salmon]

Hi Swuehl,

Can we use only function for set analysis if there is no aggregate function we are unsing?

For exmaple, i am taking one field name as my expression?

So, can i use only ( {SET EXPRESSION} FIELD)????

[swuehl]

You can use the only() function and use set analysis, since only() is also an aggregation function.

Note that Only() will only return a value if there is one distinct value possible as result when iterated over the possible record set.

The Only Function