Limit data to 10000 rows in straight table

[ashishp]

Hi There 

We want to show always 10,000 rows in straight table without using any extension. 

Can it be possible? 

I have used following in the Data Handling settings on Staight table , 

1. Count(filedname)<=10000

2. Rowno(TOTAL)<=10000 

Nothing is working , can you please suggest? 

Thanks in advance. 

[Timario]

Hi. try write next expression in new measure. if(RowNo(total) <= 10000, measure)

And last action in properties of table 

Add-Ons -> Data processing (or similar, 'Data handling'? I am not using the english version) -> Disable 'Show NULL values'.

I try this for 10 values.

[ashishp]

@Timario  Thanks for your suggestion. I have Show Nulls disabled.  

I found the issue. when we use below expression, only first 10000 records are show in the table.

Count({<NumberOfRows={"<=10000"}>}YourMeasure)

However requirment is like this.

Show 10000 records for selected region from filter. We have 6 regions , if user selects region NA then 10,000 records for that region should show. 

[deepanshuSh]

Use it like this, Create a variable vS_Field= GetfieldSelections(Field name) and then put it in set expression.

Count({<NumberOfRows={"<=10000"}, Yourregionfield={'$(vS_field)'}>}YourMeasure) this would filter out based on the region which you select. The selected field gets fed into the variable and that is called in the set expression. 

[ashishp]

I tried all possibilities , still not working, Please find attached QVF file for reference. 

[Or]

Using the latest Qlik Sense version, you could probably achieve this with a script that loops through the values and deletes anything after the 10000th iteration...

A use case for the new chart-level scripts!

[ashishp]

Thanks @Or  I am looking to achieve this front end not in the script.  

[Or]

Chart-level scripting is, by definition, chart-level, so it's on the front end. It's new in QS August 2022, and poorly documented, but it sounds like it might help achieve what you want.

[ashishp]

Any suggestions ? 

[NadiaB]

Hi @ashishp 

Are you trying to make that limit based on a calculation? or the first 10000 rows on the table? 

The only think I can think of if you want to show for example top 10000 Sales, it will be to use the Limitation(fixed number) option  for the dimension in question. 

Is there any particular reason that you want to limit the amount of rows? Maybe if you could provide a little more information about what you are trying to achieve the community might have some ideas for that specific business need.

Kind Regards,