Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
bhoomika_101
Contributor II
Contributor II

Negative Amount

I have payment amount in negative and decimal also. How to check less than 0 and greater than 0 amount?amount1.PNGamount.PNG

Labels (1)
1 Solution

Accepted Solutions
Anders_Eriksson
Partner - Specialist
Partner - Specialist

Seriously? Well easiest is to just check the value;
  if(payment_amount, 1, 0)
That will check for any non Zero value.
Or if you want to make it a little more clear what you are doing;
  if(payment_amount <> 0, 1, 0)

View solution in original post

1 Reply
Anders_Eriksson
Partner - Specialist
Partner - Specialist

Seriously? Well easiest is to just check the value;
  if(payment_amount, 1, 0)
That will check for any non Zero value.
Or if you want to make it a little more clear what you are doing;
  if(payment_amount <> 0, 1, 0)