11 Replies Latest reply: Mar 1, 2018 3:42 AM by Diiip Kumar

# By Expression color in qliksense.

i tried this below expression.

=if(Date(Date_1)>Today(),If((NetWorkDays(Date(Date_1),Today()))<10,'0-10',If((NetWorkDays(Date(Date_1),Today()))<20,'10-20','+20')),

If(((NetWorkDays(Date(Date_1),Today()-1))<10)*-1,'0-(10)',

If(((NetWorkDays(Date(Date_1),Today()-1))<20)*-1,'(10)-(20)','(20)+')))

we required + Values should be Green() and - Values be in Red.

• ###### Re: By Expression color in qliksense.

Hi Dilip,

=if you are using the same expression in Measure then you can try something like this in Color By Expression :

if(Column(1)>0,Green(),red())

if different expression in the Measure then can you check you're if condition.

=if(Date(Date_1)>Today() AND  If((NetWorkDays(Date(Date_1),Today()))<10,'0-10',

if(Date(Date_1)>Today() AND If((NetWorkDays(Date(Date_1),Today()))<20,'10-20','+20')),

If(((NetWorkDays(Date(Date_1),Today()-1))<10)*-1,'0-(10)',

If(((NetWorkDays(Date(Date_1),Today()-1))<20)*-1,'(10)-(20)','(20)+')))

Thanks,

Mukram

• ###### Re: By Expression color in qliksense.

Thank you for comment.

we tried but not expected results

• ###### Re: By Expression color in qliksense.

Which Version you are using probably if it is old , you are not able to get color by expression try to load latest version and check.

Vikas

• ###### Re: By Expression color in qliksense.

Qliksense 3.2 SR4

• ###### Re: By Expression color in qliksense.

Hi,

can you attach sample file let me check the if condition

Thanks,

Mukram.

• ###### Re: By Expression color in qliksense.

we can not attach the file . its confidential

• ###### Re: By Expression color in qliksense.

I'm using in Dimension.

• ###### Re: By Expression color in qliksense.

How to chnage color in qlik sense by expression:-

Hi,

Here I have attached a simple example how to change the color of graph based on expression in qlik sense

In my example ,

Dimesion-----year(2009,2010,2011,2012)

Measure----Sales(Sum)

Go to:----

Appereances----colors and legands--------colors(select custom)---by expression-----

then apply whatever condition you want to apply in graph.

I have given simple example of expression:

if(Year='2009',Blue(),Yellow())

• ###### Re: By Expression color in qliksense.

thank you vivek anand,

Im Using calculated Dimension as

=if(Date(Date_1)>Today() AND  If((NetWorkDays(Date(Date_1),Today()))<10,'0-10',

if(Date(Date_1)>Today() AND If((NetWorkDays(Date(Date_1),Today()))<20,'10-20','+20')),

If(((NetWorkDays(Date(Date_1),Today()-1))<10)*-1,'0-(10)',

If(((NetWorkDays(Date(Date_1),Today()-1))<20)*-1,'(10)-(20)','(20)+')))

• ###### Re: By Expression color in qliksense.

HI,

You can do thing. use a create a master item and divide your demensions into two category +ve and -ve then you you easily change the color of dimension ...

whatever will comes into +ve ,it will show into one color and rest of the things will be in the other color

try this and tell me