Expression is yielding wrong result

Fri, 13 Jul 2012 17:57:25 GMT

The following two expressions yield the same result:

Count ( Shipments)
Count ( if ( FeeOne >0 , Shipments , 0 ) )

However, there are values present in the data set in which FeeOne is <=0. I tried turning off ‘Suppress Zero-Values’ in the ‘Presentation’ tab, to no avail. Expression #2 (above) should equal a number less than Expression #1 (above).

The end result should be two expressions similar to the following, where one expression will equal the total number of shipments with a FeeOne>0 and the other will equal the total number of shipments with a FeeOne <=0.

Count ( if (FeeOne >0, Shipments, 0 ) )
Count ( if (FeeOne >0, 0 ,Shipments ) )

Count({$<FeeOne = {'>0'}>}Shipments)
Count({$<FeeOne = {'<=0'}>}Shipments)

None of the above examples are working. For syntax purposes, please note that the two expressions will be used in a stacked bar graph. Can anyone help?

Re: Expression is yielding wrong result

swuehl — Fri, 13 Jul 2012 18:06:30 GMT

0 (zero) is a value and will count for the count()

You need to use

=count(if(FeeOne >0,Shipments))

i.e. if FeeOne is <=0, NULL is returned, which doesn't count for the count()

edit:

If you need to count the records with NULL, try Nullcount(Shipments)

topic Expression is yielding wrong result in QlikView

Expression is yielding wrong result

Re: Expression is yielding wrong result