Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

@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
Master II
Master II

@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

Creator III
Creator III

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

Much appreciated