topic Re: Heat map on table 8X12 (96 well map) in QlikView

Heat map on table 8X12 (96 well map)

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

Does anyone can point me to some documentation, extension or strategy on how to perform a heat map on a 96 well plate (8x12 table). I attached example of the well map that I do in R with a data table. To give some context, we are performing an assay in a 96 well plate which is like a 8x12 table. I would like to identify pattern due to process failure. The data table will be a list of plate ID with all the coordinate and value, the list of plate will be shown in a table then when a plate is clicked the heat map will be shown.

The reported data look like this:

Plate ID	Plate Well	Value
P7379-BAR	G:3	4365868
P7379-BAR	H:1	3845954
P7379-BAR	D:1	3939838
P7379-BAR	F:8	5251712
P7379-BAR	A:1	4319556
P7379-BAR	F:7	4572828
P7379-BAR	G:4	4722496
P7379-BAR	D:2	3966063
P7379-BAR	C:6	4822168
P7379-BAR	C:4	4831038
P7379-BAR	D:5	4335659
P7379-BAR	C:8	5168929
P7379-BAR	A:6	4654479
P7379-BAR	H:2	3973021
P7379-BAR	H:3	4596488

Many thanks,

Christian

Re: Heat map on table 8X12 (96 well map)

maxgro — Wed, 30 Nov 2016 18:22:42 GMT

IIf I understand with a pivot table

Some help here http://qlikviewcookbook.com/list-recipes/

Look at Heat table chart

and Pivot table grids

Re: Heat map on table 8X12 (96 well map)

MarcoWedel — Wed, 30 Nov 2016 23:17:03 GMT

Hi,

maybe one solution could be:

tabPlateWellAssay:
LOAD [Plate ID],
    [Plate Well],
    SubField([Plate Well],':',1) as [Plate Row],
    SubField([Plate Well],':',2) as [Plate Column],
    Num(Value,'#,##0') as Value
FROM [https://community.qlik.com/servlet/JiveServlet/download/1169145-255874/QV%20plate.xlsx] (ooxml, embedded labels, table is Sheet1);

hope this helps

regards

Marco

Re: Heat map on table 8X12 (96 well map)

Thu, 01 Dec 2016 18:37:48 GMT

This look good. I will try to replicate.

Many thanks,

Christian

Re: Heat map on table 8X12 (96 well map)

MarcoWedel — Thu, 01 Dec 2016 19:56:42 GMT

You're welcome.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Re: Heat map on table 8X12 (96 well map)

MattSullivan23 — Tue, 29 Apr 2025 12:01:18 GMT

Hey Christian,
I’ve done something similar using ggplot2 in R—just convert the well positions to numeric row/column coordinates and use geom_tile() for the heat map. Works great for spotting patterns like edge effects or pipetting errors.

If you're managing multiple plates, consider a Shiny app for interactivity. Also, sketching layouts with a 96 well plate template beforehand can help avoid setup mistakes and streamline your workflow.

Let me know if you want a quick code snippet!