Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

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
Chanty4u
MVP
MVP

on which value you want to filter?

field is inventory

what about value?

hammermill21
Creator III
Creator III
Author

Hi,

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

sunny_talwar

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

hammermill21
Creator III
Creator III
Author

Hey Sunny,

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

Capture.PNG

sunny_talwar

Can you post an image of your data model?

hammermill21
Creator III
Creator III
Author

DataModel.PNG

sunny_talwar

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

hammermill21
Creator III
Creator III
Author

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
Specialist
Specialist

is it gives you a right value

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