Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


Dimension Limiting in Qlik Sense

How do I limit a dimension in QlikSense to the first 8 values of the dimension?  In QlikView I can do this easily.  Qlik Sense seems to want to limit based on a measure and not the dimension.

Tags (1)
2 Replies
Honored Contributor II

Re: Dimension Limiting in Qlik Sense

If(rank(region)<=8, region, null())

Create the calculated dimension above then exclude null values in the dimension.

Valued Contributor III

Re: Dimension Limiting in Qlik Sense

top 5.png

Hi Carl,

I got top 5 serial numbers with the help of limitation like above

Community Browser