topic Re: Showing Negative only values in expression in QlikView

Showing Negative only values in expression

AH — Wed, 25 Nov 2020 16:16:04 GMT

Could you help me showing the negative amount in this expression?

If(Type = 'D', Sum({<FactType = {'T'}>}Amount)

, If(Type = 'C' AND GL = '1001', 'Show Negative Amount Only'

, Sum({<FactType = {'T'}>}Amount)))

Thank you. Much appreciated

Taoufiq_Zarra — Thu, 08 Oct 2020 14:20:02 GMT

@AH are you looking for ?

=sum({<Amount={"<0"},FactType = {'T'}>}Amount)

for example :

AH — Thu, 08 Oct 2020 17:53:12 GMT

That is the correct answer. Thanks for the help Taoufiq!

Much appreciated