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

Play the video

Subject: Re: Count() on Distinct, but want to include additional condition
From: "Joris Gillis" <roac@xxxxxxxxxx>
Date: Wed, 10 Aug 2005 17:14:40 +0200

Hi,

Tempore 17:06:07, die 08/10/2005 AD, hinc in xsl-list@xxxxxxxxxxxxxxxxxxxxxx scripsit Ian E. Powell <Ian.Powell@xxxxxxxxxxxxx>:

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

Current Thread
Count() on Distinct, but want to include additional condition Ian E. Powell - 10 Aug 2005 15:06:23 -0000 Joris Gillis - 10 Aug 2005 15:13:57 -0000 <=

<- Previous	Index	Next ->
Count() on Distinct, but want, Ian E. Powell	Thread	Sorted node set and following, Nick Fitzsimons
Count() on Distinct, but want, Ian E. Powell	Date	Re: XSLT Element Precision, Jacquo Johnson
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >