topic Counting Only From the Right Table in QlikView

Counting Only From the Right Table

christian77 — Thu, 27 Jan 2011 16:41:26 GMT

Hi people:

I have a problem.

I´m trying to count item_id. This field appears in two tables. When I count, it counts from both tables. I wanna count only from one of them.

How can I do that.

Please help me.

I´m posting example.

Thanks in advance.

Counting Only From the Right Table

spividori — Thu, 27 Jan 2011 16:51:36 GMT

Hi.

In the script add:

left join(Items)
load Item_id,
Item_id as ItemCount
resident Items;

and then count ItemCount.

I hope help you.

Regards.

Counting Only From the Right Table

Thu, 27 Jan 2011 16:55:59 GMT

Hello,

You may try this, Join the Peso field to the Items table and store it in Items and then drop the table OtraTabla: This way you will drop the field Item_ID from Otra Tabla, but retain the Peso data within Item Table.

Mama

Counting Only From the Right Table

Thu, 27 Jan 2011 16:56:10 GMT

Hi,

Try this:

count({$<~Peso={'*'}>} distinct Item_id)

Hope this helps

Regards!

Counting Only From the Right Table

matt_crowther — Thu, 27 Jan 2011 16:59:26 GMT

I might be missing something totally obvious here but the below in a text object works for me:

=count(if(len(Color)>1, Item_id))

It works when selections are made and selection aren't??

Hope that helps,

Matt - Visual Analytics Ltd