topic Re: Count If in QlikView

Count If

Thu, 19 May 2011 14:03:21 GMT

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

Count If

Thu, 19 May 2011 14:30:50 GMT

Marco, Check this helps you

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

- Sridhar

Re: Count If

Thu, 19 May 2011 14:49:46 GMT

Thank you!!

It’s correct!

MArco

Count If

Thu, 19 May 2011 14:57:09 GMT

For a static test like that I would recommend you put the workload onto the script and use a flag, something like:

if ((AGE = 18 or AGE = 19) and GENDER = 'M', 1, 0) as YoungMaleFlag

then you can just use a simple expression in charts etc

sum(YoungMaleFlag)

Regards,

Gordon

Re: Count If

Wed, 01 Jun 2011 15:00:02 GMT

Hi Sridhar,

i' ve to do another similar count if. This time i need to count all Name with gender M and age <=18.

I try to adapt your script like these:

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

It's not correct. Can you help me?

Thank you!

Marco

Re: Count If

Wed, 01 Jun 2011 15:00:55 GMT

Hi Sridhar,

i' ve to do another similar count if. This time i need to count all Name with gender M and age <=18.

I try to adapt your script like these:

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

It's not correct. Can you help me?

Thank you!

Marco

Re: Count If

Wed, 01 Jun 2011 15:34:00 GMT

Macro,

try this

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

- Sridhar

Re: Count If

Wed, 01 Jun 2011 15:42:54 GMT

It works!! Thank You a lot!

Marco

Re: Count If

Mon, 06 Jun 2011 13:12:57 GMT

Hi,

i've to do another type of count if;

AGE <= of a numeric variable "VARIABLE" like the example:

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

But i 've problem...

Marco

Re: Count If

Mon, 06 Jun 2011 13:13:26 GMT

Hi,

i've to do another type of count if;

AGE <= of a numeric variable "VARIABLE" like the example:

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

But i 've problem...

Can you help me again?

Marco

Re: Count If

Mon, 06 Jun 2011 13:37:26 GMT

try this

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

Re: Count If

Tue, 07 Jun 2011 09:45:50 GMT

I try

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

Re: Count If

Tue, 07 Jun 2011 09:46:27 GMT

I try

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

Re: Count If

Tue, 07 Jun 2011 12:35:13 GMT

Macro,

As suggested by Vladimir, the expression should work.

Look at the attched application.

Hope this helps you.

- Sridhar

Re: Count If

Tue, 07 Jun 2011 13:28:57 GMT

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

Re: Count If

Tue, 07 Jun 2011 13:29:18 GMT

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

Count If

Wed, 04 Jan 2012 08:08:01 GMT

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

Count If

Wed, 04 Jan 2012 08:09:20 GMT

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

Re: Count If

Miguel_Angel_Baeyens — Wed, 04 Jan 2012 08:10:55 GMT

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

Count If

Wed, 04 Jan 2012 14:17:15 GMT

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???