xsl-list
[Top] [All Lists]

Re: Count() on Distinct, but want to include additional condition

2005-08-10 08:14:40
Hi,

Tempore 17:06:07, die 08/10/2005 AD, hinc in 
xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com scripsit Ian E. Powell 
<Ian(_dot_)Powell(_at_)mdbuyline(_dot_)com>:

I am having a lil issue with a count(distinct element) situation. I am
pretty new to XSLT scripting and the issue seems rather trivial.
Generating the Unique MDBService elements works great but I also want to
include 2 counts per distinct MDBservice based upon MDBDivision.
(ie) count(  MDBService and MDBDivision = "MCAP") & count(  MDBService
and MDBDivision = "HSS")

I'm not sure what you're looking for precisely (what ouput do you expect with 
the sample?) - but here's a guess:

count(key('service',MDBService)[MDBDivision ='MCAP'])
&
count(key('service',MDBService)[MDBDivision ='HSS'])

regards,
--
Joris Gillis (http://users.telenet.be/root-jg/me.html)
Vincit omnia simplicitas
Keep it simple

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



<Prev in Thread] Current Thread [Next in Thread>