How to use Multiple Conditions

[Anonymous]

How to use more than one condition, in my case I have list of associates in different locations (onsite, offshore) and one more column with salary. Now I want the data with location wise whose salary is less than $1000. Please help me on this

[eduardo_dimperio]

Hi, could you please show me an example of Input and Output?

[Anonymous]

Here are the sample details

Name	Location	Hours Entered	Available hours	Delta%
Sam	Onsite	189	189	100.00
John	Onsite	144	189	76.19
Kandy	Offshore	180	189	95.24
Satish	Offshore	162	189	85.71
Arjun	Offshore	168	168	100.00

Here I need a pie chart with onsite and Offshore count whose Percentage  is less than 100

[eduardo_dimperio]

Assuming that you already have this fields you can do this:

Dimension: Name

Measure: Count({<Delta= {"< 100"}, Name={"Offshore"}>}Delta)

[Anonymous]

Hi Sujeeth,

Welcome to the Qlik Community! We happy to have you here.

I have edited the title of this thread from "Hi" to "How to use Multiple Conditions" to make it more descriptive. I've also moved it from the Qlik Community Information space to the New to QlikView space, as that is more appropriate for this content.

In the future, please use short but descriptive titles and look for the space that is most fitting for your question, as that will help you get the best responses to your questions.

Thank you!

Qlik Community Team

[Anonymous]

Thank so muck for the quick solution