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: 
ArchanaB
Contributor III
Contributor III

Data handling condition not recognizing negative values

Hi,

 

I am facing issue in Datahandling condition.  I need to suppress records with negative sales Values (highlighted in below screenshot. My expression for sales value = Sum({<source_file_name={'CLOSED_PERIOD_SALES'}>}Amount_USD).

 

I have condition in data handling "if(Sum({<source_file_name={'CLOSED_PERIOD_SALES'}>}Amount_USD)<0,1,0)"  and unchecked include zero checkbox in datahandling. It should give me these negative records, instead it does not give me any data.

I am not sure what I am doing wrong here, Can anyone please help me with this issue.

ArchanaB_0-1608017604282.png

thank you in advance.

 

0 Replies