I am a beginner using Qlik and i have run into a problem which i am not able to solve. I think it is very basic, but i cant solve it.
I have data in two different tables where the first table has a list of products, one on each row.
The second sheet contains information about in which stores these are available. Here the same product can be found in multiple rows when they are found in multiple stores. This table has columns including product/store_number an id which is matched by the products id, and another id for the combination store+product.
How do I make a heatmap where i have stores on each axis, and all the numbers show the total number of items that both stores have in common?