Fairly new to Qlik Sense, but will try to explain in detail. I want to illustrate buying patterns with a correlation analysis but with Color so that the user directly can see the patterns. For example how often are products bought together.
I have figured out how to show all the variations of ProductCategory Names, showing how many orders these occur on and the Product Category IDs.
But I want to illustrate more by adding colors and "highlighting" which product Categories occur on the order. I need some sort of a measure column (with a function such as SubField or Match) to highligt the IDs by color. The table below is where I am at the moment, and the second picture is what I want to achieve.
The aim is to have a column that shows all the ProductID values (1-4), but only highlight the ones that occur in the third column ie. For Accessories, Bikes I want to print the four ProductCategory values, but only in some way highlight 1 and 4.
