Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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