topic Re: Multiple conditional counts in Set Analysis in QlikView

Multiple conditional counts in Set Analysis

hammermill21 — Mon, 20 Nov 2017 16:18:56 GMT

Hello!

I am trying to count individual inventory items and have them sorted on my table. So each field is called:

[Inventory Bascom Item Type] and has Data like FIRE EXTINGUISHER, EXIT LIGHTS and I want to be able to count them all then have them sorted in my table.

I'm attaching a shot of my table and how it's has the items listed.

Thank you!!

Re: Multiple conditional counts in Set Analysis

devarasu07 — Mon, 20 Nov 2017 16:40:01 GMT

Hi,

you can try like this

=Count (Total <[Bascom Item Type]> [Inventory Bascom Item Type])

=Aggr(count(DISTINCT [Inventory Bascom Item Type]),[Bascom Item Type])

Regards,

Deva

Re: Multiple conditional counts in Set Analysis

hammermill21 — Mon, 20 Nov 2017 19:01:37 GMT

Hey Deva,

Thank you. Though that does count the inventory it doesn't count the items individually. I want to be able to put a count for each items on the table.

Re: Multiple conditional counts in Set Analysis

vishsaggi — Mon, 20 Nov 2017 19:06:36 GMT

What is your expected output?

Re: Multiple conditional counts in Set Analysis

hammermill21 — Mon, 20 Nov 2017 19:07:49 GMT

What I want is on the first row for Battery operated egress lighting to show that count of the inventory, the next line would be the exit lights and so on. Make sense?

Re: Multiple conditional counts in Set Analysis

vishsaggi — Mon, 20 Nov 2017 19:10:40 GMT

Yes, i mean what value are you expecting for that Item like if you count item for that item there is only one 1 value so the count will be 1, is this what you want to see?Can you share some sample file to look into?

Re: Multiple conditional counts in Set Analysis

hammermill21 — Mon, 20 Nov 2017 19:32:00 GMT

I have attached a sample.

On the table labeled "UMHC-Bascom palmer eye institute" the last column should have the individual count for each "item type".

So for Battery operated egress lighting the total is 30, Exit lights is 307, fire extinguisher is 128 and that data is under the Inventory Bascom Item Type.

Re: Multiple conditional counts in Set Analysis

vishsaggi — Mon, 20 Nov 2017 20:26:24 GMT

Your Bascom Item Type table and Inventory tables are not linked in your Data Model? Can you explain further?