topic Minimum value different from 0 in QlikView

Minimum value different from 0

Anonymous — Wed, 30 Nov 2011 09:52:41 GMT

This expression is OK but doesn't work properly.

if([ENERGY YELDED]>0,(max([ENERGY YELDED]))-min([ENERGY YELDED]))

I want that the expression does not consider the value 0 and the a minimum value different from 0

For examplie :

ENERGY YELDED value :

MAX = 12 MIN = 4 = MAX - MIN = 8

Anybody can help me?

Thanks

lironbaram — Wed, 30 Nov 2011 10:27:09 GMT

if(min([ENERGY YELDED ])=0,max([ENERGY YELDED ])-min([ENERGY YELDED ],2),max([ENERGY YELDED ])-min([ENERGY YELDED ]))

Luis_Cortizo — Wed, 30 Nov 2011 10:35:33 GMT

Another way to do the same:

=Max([ENERGY YELDED])-Min( {<[ENERGY YELDED]= {"=Min([ENERGY YELDED])>0"}>} [ENERGY YELDED])

Anonymous — Wed, 30 Nov 2011 13:50:46 GMT

Thanks Icz,

works great !

Anonymous — Wed, 30 Nov 2011 13:54:31 GMT

i tried this expression but doesn't work....

Thanks anyway