Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
AH
Creator III
Creator III

Showing Negative only values in expression

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

1 Solution

Accepted Solutions
Taoufiq_Zarra

@AH  are you looking for ?

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

for example :

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@AH  are you looking for ?

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

for example :

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
AH
Creator III
Creator III
Author

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

Much appreciated