Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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