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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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)