topic Re: Reset the Limit of Rows (MaxNumShown) in QlikView

Reset the Limit of Rows (MaxNumShown)

chrisg — Fri, 16 Aug 2013 14:09:18 GMT

Hi,

i am using the following Marco to limit the number of rows:

(The limit in this example, is 1000)

sub limitRow

set chart = ActiveDocument.GetSheetObject("CH02")

'set chart = ActiveDocument.Activesheet.CreateStraightTable

'tb.AddField "Member"

set cp = chart.GetProperties

cp.TableProperties.MaxNumShown.v = 1000

chart.SetProperties cp

SET p = chart.GetProperties

chart.SendToExcel

end sub

I would like to reset the value back to the original value.

So from '1000' to NO LIMIT. Unfortunately I have no idea how to do that.

Many Thx

Christoph

Gysbert_Wassenaar — Fri, 16 Aug 2013 14:33:59 GMT

Try setting it to 0. That causes it to show all records again here (using QV11.2).

chrisg — Fri, 16 Aug 2013 14:43:15 GMT

Hi Gysbert,

many thx - but the result is 0 (QV 10)

😞

marcus_sommer — Fri, 16 Aug 2013 15:01:42 GMT

Set the value on true (...v. = true).

- Marcus

chrisg — Fri, 16 Aug 2013 15:08:40 GMT

Danke! Cool