# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Color mix expression with if condition

Hi I am trying to give a gradient color using if stmt and color mix func to a barchart iam working on. can i get some help here. I cant get the code right its not working for me.

if(year([Applied Date])=year(today()), colormix1(rank(total column(1))/noofrows(TOTAL), rgb(255, 0, 102), rgb(255, 204, 224)))

this is my data

 year([date field]) month([date field]) measure 2017 May 67,718 2017 Jun 84,459 2017 Jul 84,692 2017 Aug 86,536 2017 Sep 75,714 2017 Oct 83,916 2017 Nov 78,621 2017 Dec 54,663 2018 Jan 105,698 2018 Feb 87,395 2018 Mar 92,941 2018 Apr 77,395 2018 May 54,646

thanks

1 Solution

Accepted Solutions
MVP

## Re: Color mix expression with if condition

Try this

If(Year(Max(Date)) = Year(Today()), ColorMix1(Rank(TOTAL Sum([#measures]))/NoOfRows(TOTAL), RGB(255, 0, 102), RGB(255, 204, 224)))

7 Replies
MVP

## Re: Color mix expression with if condition

Would you be able to share your qvf file to check this out and play around with a little bit?

Contributor

## Re: Color mix expression with if condition

HI Sunny, Iam working on the enterprise version. Let me create the qvf in desktop version and send it over.

Contributor

## Re: Color mix expression with if condition

Hi Sunny here is the qvf.

how ever in the actual app, I have a calculated measure to show 12 month rolling period. I assume it doesn't matter how iam using my measure calculation as long as you have workable chart and data?

let me know if this works. thanks for your time and help on this .

Contributor

## Re: Color mix expression with if condition

hi Sunny I am tying to give diff gradient color for each year .

if([date=year(today()), colormix1(rank(total column(1))/noofrows(TOTAL), rgb(255, 0, 102), rgb(255, 204, 224)),

if(date=year(today())-1,colormix1(rank(total column(1))/noofrows(TOTAL), rgb(204, 51, 0), rgb(255, 102, 51))))

MVP

## Re: Color mix expression with if condition

Try this

If(Year(Max(Date)) = Year(Today()), ColorMix1(Rank(TOTAL Sum([#measures]))/NoOfRows(TOTAL), RGB(255, 0, 102), RGB(255, 204, 224)))

Contributor

## Re: Color mix expression with if condition

Hi Sunny thankyou for working on this. Re: Applying Color gradient for Bar Chart in Qliksense  discussion helped be to understand the concept iam looking for.

in the code , we should also consider the number of dimensions we are using in our visual , it will do the trick.

the exact code i used in my actual app is

if([ Year]=year(today()), ColorMix2( (rank(total column(1))/(noofrows(TOTAL)/6))-1 ,rgb(0,112,200),rgb(142,180,227),rgb(198,217,241)),

if([Year]=year(today())-1,ColorMix2((rank(total column(1))/(noofrows(TOTAL)/6))-1,rgb(204, 204, 0), rgb(255, 255, 179),rgb(189,0,98))))

thanks again for looking into this.

MVP