topic Re: limit # of rows for straight table export in QlikView

limit # of rows for straight table export

kmstephenson — Wed, 25 Mar 2015 21:39:26 GMT

Hi All,

I'm hoping to limit the number of rows (100) an end user can export from a specific table at a time. I tried using dimension limits, showing only first 101 values with Show Others checked and Collapse Inner Dimensions checked. However, I am allowing interactive sort for my straight table so if a user sorts on anything other than MRN (the first dimension), it shows the first 100 MRNs for each value of the field sorted by instead of still showing only 100 total rows.... Any way around this to either show always first 100 MRN (and sort on this) or first 100 of the field sorted by?

Re: limit # of rows for straight table export

rwunderlich — Wed, 25 Mar 2015 22:30:18 GMT

Instead of DImension LImits, use the Presentation -> Max Number = 100. That will show the first 100 based on whatever sort order the user choses.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: limit # of rows for straight table export

kmstephenson — Thu, 26 Mar 2015 13:41:21 GMT

Hi Rob,

Thanks for the quick response! I did try this out when I was looking for a solution but it appears to me as if there is no easy way to get at the next 100 rows.... We would like them to have access to all of the data but be able to select "Next" or something like this to be able to view more data... Any ideas?

Thank you!

Re: limit # of rows for straight table export

Gabriel — Thu, 26 Mar 2015 13:55:36 GMT

Hi,

I will try using Calcuation Condition on General tab of the chart.

click the ellipsis (...) then enter

= Dimension_Primary_Key <= 100

This will ensure nothing greater than 100 is displayed in the chart and exported.

NB:

Dimension_Primary_Key is the field name that identify each row in the table

Re: limit # of rows for straight table export

kmstephenson — Thu, 26 Mar 2015 14:05:05 GMT

Hmmmm this doesn't appear to be subsetting the table at all- would this limit to 100 rows displayed but allow the user to make a selection to view the next 100 rows, and so forth?

Re: limit # of rows for straight table export

Gabriel — Thu, 26 Mar 2015 14:35:57 GMT

No.

It will display 100 row.

What's your requirement?

Re: limit # of rows for straight table export

stigchel — Thu, 26 Mar 2015 14:57:50 GMT

You can maybe use a class or rank function and put them in a listbox to select in sets of 100. I have attached an example for reference

Re: limit # of rows for straight table export

kmstephenson — Thu, 26 Mar 2015 15:29:09 GMT

I want to display 100 at a time but allow the user to click a Next button (or something similar) to view the next 100.

Re: limit # of rows for straight table export

stigchel — Thu, 26 Mar 2015 15:32:24 GMT

Have you seen my example up in the thread?

Re: limit # of rows for straight table export

kmstephenson — Thu, 26 Mar 2015 15:51:24 GMT

This is awesome, thanks for sharing! It does look like you have to know how you want the data sorted though. I want to show the first 100 MRNs no matter how the data is sorted. I have ~8 columns in the straight table, so no matter how the table is sorted (user can double click a column to sort by it), I want to show the first 100 with an option to select "Next" to show the next 100....

Re: limit # of rows for straight table export

kmstephenson — Thu, 26 Mar 2015 16:18:39 GMT

Yes, I responded above, sorry it took so long I was looking at the code Has anyone tried using RowNo(TOTAL) as an Expression and using the first 100 rows this way? It fixes the sort issue but just not sure how to show the next 100....