topic Re: count matching in QlikView

count matching

Anonymous — Wed, 15 Apr 2015 08:32:21 GMT

hi,

ı have a very simple question, that you might all know

ı have 2 tables

a , b

x , a

y , b

, c

, d

ı want to distinct count values in table b but only the matching ones ( a ,b)

when a basicly count(distinct ) values in table b, it counts all the values (a,b,c,d) but ı want just the matching ones with table a.

(the two tables are joined, no prblm)

thnks for any helps.

Re: count matching

oknotsen — Wed, 15 Apr 2015 08:37:00 GMT

How about something like this:

=count( { < SomeField = SomeOtherField> } distinct SomeField)

Re: count matching

Anonymous — Wed, 15 Apr 2015 08:44:02 GMT

It does not solve.

The Two tables are already joined.

table a , table b

ID ID ID2

x , x , a

x , x, a

y , y, b

z , c

t , d

ı need the distinct count of column ID2 (matching ones)

Re: count matching

Anonymous — Wed, 15 Apr 2015 09:04:34 GMT

Any helps?

Re: count matching

Wed, 15 Apr 2015 09:08:00 GMT

If i understood your logic you need count result as 2 isn't it? or else

Re: count matching

anbu1984 — Wed, 15 Apr 2015 09:14:06 GMT

T1:

Load *,ID As ID_Cpy Inline [

];

T2:

Load * Inline [

ID , ID1

x , a

y , b

, c

, d ];

=Count(DISTINCT If(Not(IsNull(ID_Cpy)),ID1))

Re: count matching

anbu1984 — Wed, 15 Apr 2015 09:22:06 GMT

T1:

Load *,ID As ID_Cpy Inline [

];

T2:

Load * Inline [

ID , ID1

x , a

y , b

, c

, d ];

=Count(DISTINCT If(Not(IsNull(ID_Cpy)),ID1))

Re: count matching

Anonymous — Wed, 15 Apr 2015 09:22:46 GMT

=Count(DISTINCT If(Not(IsNull(ID_Cpy)),ID1))

that was all I need.

Thank you very much my friend.

for your help.