topic AW:How to count valuse from possiable value list?? in QlikView

How to count valuse from possiable value list??

david_ze — Mon, 14 Mar 2011 20:06:35 GMT

hi,

I have two tables: A and B:

I would like to count column C each time the A value exists in both table.

In the above example the result should be 5.

How should I do this?

Will appreciate your help.

Thanks in advanced,

David

Mon, 14 Mar 2011 21:20:58 GMT

Hello David,

since I do not know where you want to use it, my suggestions:

a) in a straight table as a calculated dim like =if(B=C, A) and an expression like count(C)

b) in a text-box like =count(if(B=C, C))

If you need it more often, I would think about doing the count during loading and store it in a new field ("D")

HtH

Roland