topic Count Distinct in QlikView

Count Distinct

Fri, 24 Feb 2017 15:09:07 GMT

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

Re: Count Distinct

sunny_talwar — Fri, 24 Feb 2017 17:10:37 GMT

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

Re: Count Distinct

Fri, 24 Feb 2017 17:33:47 GMT

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

I need to do this with the result 0.

Re: Count Distinct

sunny_talwar — Fri, 24 Feb 2017 18:07:49 GMT

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

Re: Count Distinct

shivkumar300 — Sat, 25 Feb 2017 10:58:19 GMT

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