Scale Limits and HyperCube Object

[sirpod]

Hello and thank you for the currently best extension in the QS branch!

I really love the idea and the implementation of this extension. It almost has everything I was searching for :)

I just would like to know a few things.

1. It is possible to dynamically scale the axis? There is a field for include values for a scale. But I would like to insert dynamic values there for different selections. It would be nice to insert Qlik variables in there or an expression.

2. Is it possible to insert more than 1000 points to the plot? When I try to display for example 3000 data points I got an exception to many HyperCubes. Is there a possibility to display it even Qlik forbid it?

3. How can I set an alternativ axis and scale the labels an ticks to the width of the amount of results? For example I want to display results over a timestamp but just want to show the day on the x-axis. Every day has a different amount of results and I would like to make ticks at the beginning and end of each day as well as labels in the middle of the ticks. But when I try to add a new scale or add the date field to the timestamp scale, the plot shows just an range on the x-axis from value 0 to 1 or makes the ticks and labels all the same width. How can I set tick position of an alternate axis?

To illustrate to issue here some pictures. Hope you understand what I am trying to explain ;-)

Original with tmiestamps:

Result if I add the date to the scale:

Result of incorrect ticks, if I add a new scale and axis

Thanks for your great work! I hope your extension will truly rise and get an award from Qlik

Regards Tobias

[AnalyticsEarth]

Hi, thanks for the feedback.

1. Yes i will add this in the next version to make the field a expression (i am gradually making all fields have this option)

2. Yes, should be, you have to set the hypercube size manually in the add-on section.

3. You can do this by having a different scale for the axis and for the line. sometimes this needs to have an extra measure to give you the higher aggregation you want on the scale. let me know how you get on and i can share an example next week.

[sirpod]

Hi, thanks for the fast feedback.

1. That's great to hear
2. I can set a maximum CubeHeight of 2000. Other I still receive the error message "To many HyperCube Objects". But somehow I see for a short moment the whole plot with all results (like I want it), but than it blanks out an the error message occurs. So it seems to be a Qlik function, which is blocking the output?!
3. I tried to set aggregation measurement to the scale for the count of the values within the date. But somehow it always changes the axis to numeric values and ignores the given width. It would be great to get an example, I somehow didn't understand it quite. But´no hurries ;-)

Thanks again & kind regards Tobias

[sirpod]

Sorry wrong button. Didn't want to close it.

[AnalyticsEarth]

the hypercube is limited to 10,000 cells by default, above this you have to page the data in and out, i am wroking ok making this functionality works correctly. So you have have 2000 height, but you need to have less width so width * height < 10000.