Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression Trouble

Currently I have a bar chart that gives me the total number of a holding bins.

However, sometimes theses hospitals have a number of different products

Currently I'm using the expression... "Count([Holding Bins])

I was wondering what kind of expression I could use to counnt the number of products in the holding bins as opposed to just the holding bins.

Hopefully that makes sense! Thanks for reading...

3 Replies
Not applicable
Author

What do you use as you dimension now?

I'm thinking you might want to make [Holding Bins] your dimensions and Count([Products]) as your expression. This assumes Products are tied to a bin. Is this what you mean?

Not applicable
Author

actually, i got it, no worries

used this expression... aggr(sum(quantity),[HoldinglBin])

Not applicable
Author

Thanks for the help Moshea, appreciate it!