topic Re: Hi in QlikView

How to use Multiple Conditions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Hi

eduardo_dimperio — Wed, 16 May 2018 18:29:35 GMT

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

Re: Hi

Anonymous — Thu, 17 May 2018 07:01:57 GMT

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

Re: Hi

eduardo_dimperio — Thu, 17 May 2018 14:38:54 GMT

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

Dimension: Name

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

Re: How to use Multiple Conditions

Anonymous — Thu, 17 May 2018 17:43:21 GMT

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

Re: How to use Multiple Conditions

Anonymous — Fri, 18 May 2018 10:41:23 GMT

Thank so muck for the quick solution