QlikView App Dev

[#1]

Hello,

I have a list of people with the following information: Name, Country, Age, Skills, Height.

Imagine that I have people from more than 20 countries, and I need to count only those that are not from "Brazil" (I want to exclude Brazil) and have more than 35 years old.

Does someone know how to do it?

Thank you very much!

[Gysbert_Wassenaar]

count({<Age={'>35'},Country-={'Brazil'}>}Name)

[#3]

Hi Gysbert,

I tried the formula you gave me, but something might be wrong, perhaps in terms of syntax. It´s appearing underlined since "Brazil" till the end (Worker ID). Below is the formula:

=count({<Age={'>35''}, WorkerNationalityName-={'Brazil'}>} DISTINCT WorkerID)

Do you know why it happens?

Thank you.

[neetha_p]

Hi

=count({<Age={'>35''}, WorkerNationalityName-={'Brazil'}>} DISTINCT WorkerID)

remove double quotes Age={'>35''}

try single quotes:

=count({<Age ={'>35'}, WorkerNationalityName-={'Brazil'}>} DISTINCT WorkerID)

[qlikrajan]

Hola Amigo!

use the expression =count({<Age={'>35'}, Country-={'Brazil'}>} Name). I have attached sample app and data set for you. Hope it helps.

Best,

[Gysbert_Wassenaar]

That's a bug in the syntax checker of the expression editor. The expression syntax is correct.

[qlikrajan]

Hey Gysbert...I have noticed that sometimes the red line comes under the expression but still expression works.