topic Re: variable greater condition in QlikView

variable greater condition

usercapricon — Wed, 21 Feb 2018 06:53:43 GMT

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

kaushiknsolanki — Wed, 21 Feb 2018 18:48:42 GMT

Hi,

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

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

Regards,

Kaushik Solanki