Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Colormix in rows instead of columns

Hi everyone!

I'm facing some issue using colormix in Qlik Sense. I have a pivot table that show me the seasonality of sales (in week days/columns) associated with my dimension (rows). That is, I want to know which day have more sales for each value of my dimension. As you see in the figure attached, the colors are not highlighting the "ranking" as expected (the red circles show a case where 20% is lighter than 17%). My colormix code used was:

ColorMix1 ((rangemin(.8,rangemax(sum(SALES)/aggr(NODISTINCT sum(SALES),DIMENSION) ,.1))-.1)/(.8-.1), ARGB(255, 242, 242, 242), ARGB(152, 203, 131, 0))

Any ideas how to fix it?

Thanksss!!

1 Reply
sjoerdoenema
New Contributor

Re: Colormix in rows instead of columns

Hi,

This code worked for me in a situation that I had myself, with your data it would look something like this:

ColorMix1(Sum(SALES)/Sum(Total<DIMENSION>SALES)/Max(Total<DIMENSION>Aggr(Sum(SALES)/Sum(Total<DIMENSION>Sales),DIMENSION,WEEKDAY)), ARGB(255, 242, 242, 242), ARGB(152, 203, 131, 0))

Give it a try!

Regards,

Sjoerd