Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ibradly
Contributor III
Contributor III

Using ColorMix2 with range greater than 100% and lower than -100%

Hi, I am trying to get a color gradient on my Click column.

I have the color gradient anything between -100%  and 100% however, anything greater or less than that range I am not able to get a color associated to it. 

This is the formula i am currently using.

if(match(only({1}Period),'WoW')>0,ColorMix2((sum({$<IsBrand=,Program=,Engine=,Device=,Category=,Week={"$(=$(vLastFullWeek))"},SharedDMA=>}Click)
/sum({$<WeekName=, Year=,Week={"$(=$(vPriorLastFullWeek))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)-1),Lightred(),Lightgreen(),white()),
if(match(only({1}Period),'YoY')>0,ColorMix2((sum({$<WeekName=, Year=,Week={"$(=$(vLastFullWeek))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)
/sum({$<WeekName=, Year=,Week={"$(=$(vLastFullWeekPriorYear))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)-1),lightred(),lightgreen(),white())))

I also attached a picture for reference of the output of my table. 

Can someone please help?

Labels (7)
0 Replies