ralfbecher / qliksense_extension_2dimheatmap Goto Github PK

I find this extension very useful but I have come across an issue regarding the order of the dimensions in the axes.

Let us have the following table:

`T_x:
LOAD * INLINE
[
Range_x,Range_Order_x,Weight
X,1,1
Y,2,2
Z,3,3
A,4,4
B,5,5
C,6,6
];

Outer Join (T_x)
LOAD * INLINE
[
Range_y,Range_Order_y
X2,1
Y2,2
Z2,3
A2,4
B2,5
C2,6
];

`

I want to plot a heatmap using the dimensions Range_x and Range_y, and the measure Weight (sum(Weight) actually). The order these dimensions need to be displayed is given by Range_Order_x and Range_Order_y, so these fields (actually their avg) are introduced in the sorting sections.

Unfortunately, this only seems to work for the Dimension 1 (Range_y). Dimension 2 (Range_x) seem to ignore the Sort by Expression option, and sort the values of the dimension alphabetically.

Note that the order of the X axis should be XYZABC according to Range_Order_X.

Thanks in advance.

Hello, is it possible to change the default colour of the tiles which have no data (appear as "-")? Currently they appear black which is not well received by our customer

I'm noticing that the background color of the cells are calculated before evaluating the numbers to display. If I round numbers to have only integers, 49.9 is displayed as 50, but as 49.9 < 50, the background color is yellow in my example.
How can I make the extension to evaluate what color to use after the rounding has been done?
Thanks

No license information at all. Please add.

Hello,

I have tried your extension... But i want to change the color based on some expression..
Is it possible to do so??
Please check the below screenshot for reference..
I want to built the same using the extension..

Thanks & Regards,
Kavita

Hi,

I'm trying to display the values on top of the heat map instead of mouse over and don't find were and how to do this.
Any one?

Thanks
Orit

Excellent work.
I found one issue.
When switching between the sheets, the extension is failed to render

Can you please fix it.
Error.txt

When applying a sort to the contents of Dim 2, this is not being honoured. The sort is being applied when the same is placed on Dim 1. As soon as move back to Dim 2, this is just listed based upon a random load order.

Need to be able to specify the sort conditions for both Dim 1 and Dim 2.

When putting the same data in a Pivot table, the sorting works correctly with the same data and sort conditions.

Hi Ralf,

When I try to export a sheet as a pdf the heatmap visualisation won't load. The error message is "Invalid visualization. The visualization was not found on the server: bi-irregular-2dim-heatmap". The visualisation shows fine within the app (now we've upgraded to the latest version).

Have you been able to successfully export the heatmap into a pdf document before?

Many thanks,

Sarah Lamb

Hi there,

Great extension - this is exactly what I need. I can create heatmaps within Qlik Sense Desktop but when I go through exactly the same process on the server the visualisation fails to render every time.

Please can you take a look into this issue for me?

Many thanks,

Sarah Lamb

When using "valueloop(0,23)" as second dimension, this result in qDimensionType[1] == 'D' (not 'N') therefore the dim2 sorting doesn't sort tiles as expected :

I'm working with AVG(AGGR(COUNT([columnA]),columnB)).
When I pick one (X,Y), it changes the value.

The first dimension of the map can be sorted by expression, but when I try to sort the second dimension, I just can do it alphabetically or numerically, the expression I write for sorting is not evaluated.