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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!