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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. 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!