2 Replies Latest reply: Dec 6, 2012 6:37 AM by sliderrules RSS

    XML null condition

    sliderrules
      Hi,

      I am trying to add a null condition to the xml behind a pie chart. I would like the data to select values that are not null on field CUST_GROUP. I have tried adding CUST_GROUP!=null in current-group() but this is throwing an error message.


      chart:
      <Graph graphType="PIE"><LegendArea visible="true" automaticPlacement="AP_NEVER" position="LAP_BOTTOM" /><SeriesItems><Series id="0" color="#666666" />
      <Series id="1" color="#E60027" /></SeriesItems><LocalGridData colCount="1" rowCount="{count(xdoxslt:group(current-group(), 'CUST_GROUP'))}">
      <RowLabels><xsl:for-each-group select="current-group()" group-by="CUST_GROUP" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
      <xsl:sort select="current-group()/CUST_GROUP" /><Label><xsl:value-of select="current-group()/CUST_GROUP" />
      </Label></xsl:for-each-group>
      </RowLabels>
      <DataValues>
      <xsl:for-each-group select="current-group()" group-by="CUST_GROUP" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
      <xsl:sort select="current-group()/CUST_GROUP" />
      <RowData><Cell><xsl:value-of select="count(current-group()/ID_NUM)" />
      </Cell>
      </RowData>
      </xsl:for-each-group>
      </DataValues>
      </LocalGridData>
      </Graph>

      Can anyone help?

      Thanks