topic How to count with two conditions. in QlikView

How to count with two conditions.

Tue, 18 Sep 2012 16:12:22 GMT

Dear all.

I have a database with three columns, the first is call "ID", the second one is call "ID del Incidente Padre" and the third one is call "Area/Subcategoria", i need to obtain the count using the three fields, for example, count the "ID" column if the column "ID del Incidente Padre" is empty, and the column "Area/Subcategoria" contain the word Evento.

How can i do this?

Sorry me english.

Best regards.

Re: How to count with two conditions.

MayilVahanan — Tue, 18 Sep 2012 16:21:02 GMT

If(ID = '', if("ID Del Incidente Padre" = '', Count(Area/SubCategoria),Count([ID Del Incidente])),Count(ID))

If(Count(ID) = 0, if(Count([ID Del Incidente Padre]) = 0, Count(Area/SubCategoria),Count([ID Del Incidente])),Count(ID))

If you want distinct count, please add the distinct in your expression

Hope it helps

Re: How to count with two conditions.

Tue, 18 Sep 2012 17:15:04 GMT

Hi.

Sorry but it doesn't work, i tried with something like that.

if((Area/SubCategoria) = 'Evento', count (if(len([ID Del Incidente Padre])=0, ID))

But it doesn't work too.

Somebody can help me??

Re: How to count with two conditions.

MayilVahanan — Tue, 18 Sep 2012 17:17:07 GMT

can you provide a sample file?

Re: How to count with two conditions.

Tue, 18 Sep 2012 17:27:43 GMT

ID	ID del Incidente Padre	Area/Subcategoria
IM345652		Incidente
IM456768	IM23456	Evento
IM453636		Evento
IM83738	IM56434	Incidente
IM63536		Evento

In the table you can see an example, we have the three columns as i explained, in this case i need to count the elements in 'ID' column, when the column 'ID del Incidente Padre' is empty and the column 'Area/Subcategoria' contain the word 'Evento', as you can see on the example the result must be 2, that correspond to the ID IM453636 and IM63526.

Best Regards

Re: How to count with two conditions.

v_iyyappan — Tue, 18 Sep 2012 17:28:53 GMT

Hi,

Can you provide me detailed information about the links between the fields "ID Del Incidente Padre",Area/SubCategoria, ID.

and what type of object you are using? and also about dimensions?which is easy to help you out.

Iyyappan

Re: How to count with two conditions.

v_iyyappan — Tue, 18 Sep 2012 17:33:18 GMT

Try something like this

Sum(Aggr(if(len(trim([ID Del Incidente Padre]))=0 and [Area/SubCategoria]='Evento',1),[ID Del Incidente Padre],Area/SubCategoria))

Iyyappan

Re: How to count with two conditions.

MayilVahanan — Tue, 18 Sep 2012 17:34:51 GMT

Try something like this,

=Count({<[Area/Subcategoria] = {'Evento'},[ID del Incidente Padre]={''}>}Distinct ID)

If(Len([ID del Incidente Padre]) = 0, Count({<[Area/Subcategoria] = {'Evento'}>}Distinct ID))

Can you provide the detail as iyyappan asked?

Hope that helps..

Re: How to count with two conditions.

Tue, 18 Sep 2012 18:35:54 GMT

Hi.

Attach you can find the example in order that you see the things that i want to obtain.

Best Regards.

Re: How to count with two conditions.

Tue, 18 Sep 2012 19:19:16 GMT

See attached.