topic Re: How can I show more than 50 rows in a Table Widget? in Integration, Extension & APIs

How can I show more than 50 rows in a Table Widget?

AguWolkovicz — Mon, 20 Feb 2017 12:22:37 GMT

I've been working on a Table Widget to customize it's styles and other stuff and it's only showing up to 50 rows for the current selection. When I export its data, I get a spreadsheet with the around 180 rows that the table is supposed to show.

Is this a limitation for the widgets?

Is there a way I can change this?

Is there a way I can paginate or something like that all the data?

Thanks in advance!

Re: How can I show more than 50 rows in a Table Widget?

Aiham_Azmeh — Mon, 20 Feb 2017 20:08:54 GMT

Hi agu440labs‌,

Yes it's a limitation (for now) - we are working on improving widgets.

rbecher‌, managed to find a workaround for it by adding ng-init in the first scope of the widget element -- his code:

<div ng-init="data.model.enigmaModel.applyPatches([{qPath: '/qHyperCubeDef/qInitialDataFetch/0/qWidth', qOp: 'replace', qValue: '20'}])"></div>

Related threads:

I hope this helps

Re: How can I show more than 50 rows in a Table Widget?

AguWolkovicz — Mon, 20 Feb 2017 20:24:50 GMT

Hi aaz‌,

Actually your solution is useful to increase the number of columns that the HyperCube will contain when looping it within the table; I found that the correct solution for increasing the number of Rows is as follows:

<div ng-init="data.model.enigmaModel.applyPatches([{qPath: '/qHyperCubeDef/qInitialDataFetch/0/qHeight', qOp: 'replace', qValue: '1000'}])"></div>

Regards,

Agu.-

Re: How can I show more than 50 rows in a Table Widget?

Aiham_Azmeh — Tue, 21 Feb 2017 06:58:16 GMT

agu440labs‌,

Yes you're right, since I never tried it myself, I was just showing you his code as an example in order to maybe help you find the solution.

In a widget, you should also be able to get more data with the table API:

<button ng-if="data.rowcount>data.rows.length" qva-activate="data.getMoreData()">More</button>

Re: How can I show more than 50 rows in a Table Widget?

rbecher — Tue, 21 Feb 2017 12:50:20 GMT

Yea, that's why you wouldn't need to patch qHeight because it's not a limit.

Re: How can I show more than 50 rows in a Table Widget?

jftalmeida — Fri, 26 Jan 2018 03:08:07 GMT

Dears,

Has this bug been fixed? Or do you have any workaround?

Thanks.

Re: How can I show more than 50 rows in a Table Widget?

tversweyveld — Fri, 06 Apr 2018 14:00:52 GMT

Hi rbecher‌,

I saw your workaround and I would like to use this technique to change the hyperCube in the widget to a different qMode. I'm trying to do it like this:

But I get a JSON parse error: Unexpected JSON token error.

Do you have any idea how to fix this?

Re: How can I show more than 50 rows in a Table Widget?

rbecher — Fri, 06 Apr 2018 14:05:41 GMT

Try this:

Re: How can I show more than 50 rows in a Table Widget?

tversweyveld — Fri, 06 Apr 2018 14:13:26 GMT

Yessssss, thank you so much!!

Re: How can I show more than 50 rows in a Table Widget?

andydietler — Tue, 15 May 2018 20:00:16 GMT

Is there any way to do this in the javascript if I'm working on an extension that doesn't have an .html file?

Re: How can I show more than 50 rows in a Table Widget?

ErikWetterberg — Tue, 15 May 2018 21:48:51 GMT

Hi,

In an extension you set qHeight in initialProperties to specify number of rows. No 50 rows limit, but max cells is 10000.

Erik Wetterberg

Re: How can I show more than 50 rows in a Table Widget?

andydietler — Tue, 15 May 2018 21:51:34 GMT

Is it possible to show more than 10 columns though? I've tried upping it to 20 and looked through all the code and there doesn't seem to be any other limiting, but the 10th column shows up with no data. It seems that Qlik is only returning 10 columns worth of data no matter what I set for qWidth over 10.

Re: How can I show more than 50 rows in a Table Widget?

ErikWetterberg — Wed, 16 May 2018 06:42:25 GMT

Since thi is no longer about widgets you should create a new thread.

Erik Wetterberg

Re: How can I show more than 50 rows in a Table Widget?

nwatson-qit — Tue, 13 Apr 2021 15:43:50 GMT

Hello all,

I realise that this thread is ancient, but in case previous posters receive an alert, can anyone kindly help?

The hack above proved to be very useful at creating a widget to display information from a single record in a form like layout, and everything was fine until the app was published. Unfortunately, any sheet that contains the widget now throws an "Access denied" error when first opened. So, I believe the problem is trying to patch the hypercube def in a published app. My problem is, I'm not even sure which resource type we should be looking to put the security exception against! Any thoughts anyone?

Thanks,