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

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())