Count If

[#1]

Hi,

i need to count the variable NAME when the AGE is 18 or 19 and GENDER is M.

If there is only one condition ( for exemple AGE) i use: count({<AGE={'18','19'}>} NAME) and it works.

How can I introduce also the second condition (GENDER=M)?

Thank you

[#2]

try this

count({<AGE={"<=$(VARIABLE)"},GENDER={'M'}>} NAME).

[#3]

I try

count({<AGE={"<=$(VARIABLE)"},GENDER={'M'}>} NAME) but there is not difference between the count with or without AGE={"<=$(VARIABLE)"}.

[#4]

I try

count({<AGE={"<=$(VARIABLE)"},GENDER={'M'}>} NAME) but there is not difference between the count with or without AGE={"<=$(VARIABLE)"}.

[#5]

Macro,

As suggested by Vladimir, the expression should work.

Look at the attched application.

Hope this helps you.

- Sridhar

[#6]

Thank you!! You and Vladimir understand my problem and with this application now i'm understand where i've made mistakes.

All it's clear! Thank you again for the great application!

Ciao

Marco

[#7]

Thank you!! You and Vladimir understand my problem and with this application now i'm understand where i've made mistakes.

All it's clear! Thank you again for the great application!

Ciao

Marco

[#8]

Hi All, how do I say not equal to? 

The example is here

count({<AGE={'18','19'},GENDER={'M'}>} NAME)

I want to say. count if Age is not equal to 18 or 19 ?

Thanks

[#9]

Hi All, how do I say not equal to? 

The example is here

count({<AGE={'18','19'},GENDER={'M'}>} NAME)

I want to say. count if Age is not equal to 18 or 19 ?

Thanks

[Miguel_Angel_Baeyens]

Hi,

In that case exclude those values from the set:

Count({< AGE -= {18, 19}, GENDER = {'M'} >} NAME)

When values are numeric, there is no need for quoting, actually that slows down the calculation, since QlikView has to deal numeric values as literals (strings)

Hope that helps.

Miguel

[#11]

Hi all,

i'm really new but well i found many things here in the community but now i really need a little help...

it schould be easy but for me it doesen't work...

i nearly need the same like this count({<AGE={"<=18"},GENDER={'M'}>} NAME)

but i will need addtional a 'distinct' for the name...

can somebody let me know how to enter that???