Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

melissapluke
New Contributor II

Limit by the Number of Rows

Hi all,

I am using a table in which the users can pick the dimensions and measures shown in the table. I'd like to add a calculation condition to limit the table to a certain number of rows, but because the user can pick from a variety of dimensions/measures, there isn't a specific dimension i can use the do something like "Get Possible Count". Does any one have any ideas of what I can use as a calculation condition to limit the table?

Thanks!

Melissa

4 Replies
MVP
MVP

Re: Limit by the Number of Rows

Are you only going to pick one dimension at a time or can you also pick multiple dimensions?

melissapluke
New Contributor II

Re: Limit by the Number of Rows

It can be up to about 50 different dimensions that can be selected.

MVP
MVP

Re: Limit by the Number of Rows

And all of these are getting selected from a dimension which is created using an Island table? If it is, may be you can do this

Count(DISTINCT $(=Concat(DISTINCT '[' & DimensionName & ']', '&')))

balabhaskarqlik
Honored Contributor

Re: Limit by the Number of Rows

May be limit the load of rows by condition base:

if(sum(aggr(1, DimA, DimB, ..., DimX)) < 100,1,0).

or

Count(Aggr(1,$(=Concat(Dim,',')))) < 100

Community Browser