Heat map on table 8X12 (96 well map)

[#1]

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

[maxgro]

IIf I understand with a pivot table

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

Look at Heat table chart

and Pivot table grids

[MarcoWedel]

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

[#4]

This look good. I will try to replicate.

Many thanks,

Christian

[MarcoWedel]

You're welcome.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco