Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
williamandersson
Partner - Contributor III
Partner - Contributor III

Correlation Analysis in table

Hi!

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.

Thanks in advance!

Labels (3)
0 Replies