Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
melissapluke
Partner - Creator
Partner - Creator

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
sunny_talwar

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

melissapluke
Partner - Creator
Partner - Creator
Author

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

sunny_talwar

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

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