Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
erku
New Contributor II

Max Amount of Measures and Dimensions

Hi,

I have simple extension with 1 dimension and 19 measures  and it works fine.

for (var i = 0; i < this.Data.Rows.length; i++) {

var row = this.Data.Rows [i];
html=row.length+"<br/>"

It return 20, it's correct.

The problem is when I add one more measure, then length of row is 21 but it still shows 20. Could anyone know why it's limited to 20 element?  Example attached. 

1 Solution

Accepted Solutions
chrismarlow
Contributor III

Re: Max Amount of Measures and Dimensions

Hi Erku,

I think there is a solution buried in this thread;

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Qlikview-Extension-Maximum-Data-Rows/td...

It is to use this.Data.SetPagesizeX(200); in the js file (where I just picked 200 as an example), so my modified script (attached) gives the following, where my 23 columns is the 22 measures and 1 dimension;

20181212_1.pngMy table is not very pretty, and there is more on the thread about using the data pages in a more robust way, but this might be a suitable enough work around.

Cheers,

Chris.

 

6 Replies
chrismarlow
Contributor III

Re: Max Amount of Measures and Dimensions

Hi,

Maybe need to set the PageHeight? I thought default was 40, but might be your issue.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Qlikview-Extension-Maximum-Data-Rows/td...

Cheers,

Chris.

 

erku
New Contributor II

Re: Max Amount of Measures and Dimensions

Hi,

No, unfortunately it's not PageHeight. 

chrismarlow
Contributor III

Re: Max Amount of Measures and Dimensions

Hi,

I've only done one of these myself … and that was what caught me.

I've tried to set up your extension, but not seeing anything & have a couple of observations, but if these are not helpful then over to someone who has done more of these I guess Smiley Happy;

1) It does not seem to generate a QVPP file - may be the way I have copied it in though. Do you see one in the folder?

2) I just get undefined (see below), which is assume an error in the script.js, but you are getting some return from same script I assume. I stuck this in a toy app with 1 dimension & 1 measure, so may be that, but the object does seem to populate 1 dimension & lots of measures.

3) Your script seems to iterate through the rows, but each time just overwrites html, is that intentional?

Cheers,

Chris.

20181207_1.png

erku
New Contributor II

Re: Max Amount of Measures and Dimensions

Hi,

Thank you for replay. 

ad1. No, I don't see. 

ad2 and 3.  It's just part of the much bigger script and I want to show only where the problem is. So overwrites is intentional but it doesn't matter. The main problem is that you will be able to get 1 dimension and 19 measures but if you add one more measures (20) it's failed. Looks like limitation of number dimensions and measures. 

Regards,

Erku

chrismarlow
Contributor III

Re: Max Amount of Measures and Dimensions

Hi Erku,

I think there is a solution buried in this thread;

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Qlikview-Extension-Maximum-Data-Rows/td...

It is to use this.Data.SetPagesizeX(200); in the js file (where I just picked 200 as an example), so my modified script (attached) gives the following, where my 23 columns is the 22 measures and 1 dimension;

20181212_1.pngMy table is not very pretty, and there is more on the thread about using the data pages in a more robust way, but this might be a suitable enough work around.

Cheers,

Chris.

 

erku
New Contributor II

Re: Max Amount of Measures and Dimensions

Hi,

Thanks, it's solved issue. 

Community Browser