
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Heat map on table 8X12 (96 well map)
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
IIf I understand with a pivot table
Some help here http://qlikviewcookbook.com/list-recipes/
Look at Heat table chart
and Pivot table grids


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This look good. I will try to replicate.
Many thanks,
Christian


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You're welcome.
Please close your thread if your question is answered:
Qlik Community Tip: Marking Replies as Correct or Helpful
thanks
regards
Marco

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
