topic Exclude negative Values from expression in QlikView

Exclude negative Values from expression

AH — Wed, 19 Aug 2015 17:29:47 GMT

Hi,

I have the expression to calculate the Units. But i am having some negative Units (Value) which i dont want to include in the calculation.

=num((Sum({<Type = {'AB','CL'},

[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')

How do i do this?

Any help please?

=num((Sum({<Type = {'AB','CL'}, Units -={},

[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')

Thanks,

Ahmed

sinanozdemir — Wed, 19 Aug 2015 17:34:11 GMT

Have you tried using it like the below:

=num((Sum({<Type = {'AB','CL'}, Units ={">0"},

[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')

maxgro — Wed, 19 Aug 2015 17:38:58 GMT

=num((Sum({<Type = {'AB','CL'},

[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>} rangemax(0,[Units]) )),'##,##0')