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

limit number of values in a straight table

Hi all!

i have a straight table with 3 dimensions (product ID is a calc dim and 2 others) and some expressions.

one of the dimensions is the City name.

I would like to limit the number of product IDs that are from the same city.

how can I do this in a straight table?

thanks!

10 Replies
dmac1971
Creator III
Creator III

Or limit the dimension to the top two items?Top Two.JPG