Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

henninghafr
New Contributor

Count Agg problem

Hi,

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?

 

Anyone has any suggestions?

cheers Henning

 

1 Reply
maxronny
New Contributor II

Re: Count Agg problem

please post an example file