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: 
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
anderseriksson
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
anderseriksson
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)