Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
usercapricon
Contributor
Contributor

variable greater condition

I want to show all employees who have greater than 10,000 amount i do this but this is not working

=if(RetBal < 10000,RetBal)

and then i save this in varaible

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Create a straight table and add Employees as dimension and below expression.

Sum(if(RetBal >= 10000,RetBal))


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!