Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

Counting Passed Total and sorting by Item Type

Hello everyone,

I am counting inspections based on them being passed:

Count({<[Bascom Pass]={'YES'}>}[Bascom Pass])

Which is working fine, but I need to filter that by the "Inventory Item Type", could someone help me with this?

Thank you!

10 Replies
sureshqv
Esteemed Contributor III

Re: Counting Passed Total and sorting by Item Type

on which value you want to filter?

field is inventory

what about value?

hammermill21
Contributor II

Re: Counting Passed Total and sorting by Item Type

Hi,

I'm sorry but I don't understand your question.

Re: Counting Passed Total and sorting by Item Type

Why don't you create a chart with the above expression and [Inventory Item Type] as a dimension?

hammermill21
Contributor II

Re: Counting Passed Total and sorting by Item Type

Hey Sunny,

That's what I did and it's counting all of the inventory types for each on:

Capture.PNG

Re: Counting Passed Total and sorting by Item Type

Can you post an image of your data model?

hammermill21
Contributor II

Re: Counting Passed Total and sorting by Item Type

DataModel.PNG

Re: Counting Passed Total and sorting by Item Type

This seems like a data model issue, but can't pin point it to anything specific... are you able to share a sample?

hammermill21
Contributor II

Re: Counting Passed Total and sorting by Item Type

Of course, thank you for looking over this for me. It's been driving me crazy! I've attached it to the original message.

zebhashmi
Valued Contributor

Re: Counting Passed Total and sorting by Item Type

is it gives you a right value

Count({<[Bascom Pass]={'YES'},[Inventory bason item type]={'Fire Door'}>}[Bascom Pass])

Community Browser