Count Distinct

[#1]

Hi everyone,

Need some help to resolve this issue (i think is an issue):

I'm using this query: "Count( {<IdRequa={'0'}, IdRes={'Qual'}>} Distinct IdSub)".

The Qlikview solve was 1.

My question or issue is I need result "count=0". When i'm using the expr {<[IdRequa]={'0'}, [IdRes]={'Qual'}>} i'm using this like a "filter" and Qlik are making this like a Distinct

The table source is below (in this exemple the column IdRes is always equal not always is, this is just a sort of total table):

IdMap	IdCandidatura	IdSub	IdRequa	IdRes
2992	2283	11	-1	Qual
2988	2282	11	0	Qual
2990	2283	22	-1	Qual
2989	2282	22	0	Qual
2986	2282	125	0	Qual

Could anyone help with this?

Many thanks

[sunny_talwar]

QlikView is giving you 1? I would think it would give you 3... and why do you want 0?

[#3]

Qlikview is giving me 1 and the line is IdMap "2988".

I need to do this with the result 0.

[sunny_talwar]

What is your logic for seeing 0? Can you elaborate?

[shivkumar300]

As per your requirement I have used below exp and result showing here is 0 & 1 according to the selection.

=if(IdRequa='0'and IdRes='Qual',0,Count( Distinct IdSub))