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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vsap2000
Creator
Creator
‎2020-12-18 03:47 PM

Filter values greater than 2000

Hello Guys,

I want to get Net Amt that is greater than 2000  or -2000 (Absolute Value) for the Sales Number using the Exact Value limitation as shown in attached file. I am able to use >= 2000 but not able to get anything >= -2000.

Thanks in advance.

-V

 

 

 

Preview file
19 KB
1,514 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2020-12-25 03:57 PM

May be this?

If(NetAmount>=2000 or NetAmount <= (-2000), NetAmount)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
1,453 Views
vsap2000
Creator
Creator
‎2020-12-28 09:17 PM
Author

In response to Anil_Babu_Samineni

Thanks for replying. I tried but it didn't work it is showing all amounts.

 

-V

 

1,424 Views
0 Likes