-
Re: By Expression color in qliksense.
Mohammed Mukram Ali Feb 28, 2018 12:26 AM (in response to Diiip Kumar )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.
Diiip Kumar Feb 28, 2018 2:15 AM (in response to Mohammed Mukram Ali)Thank you for comment.
we tried but not expected results
-
Re: By Expression color in qliksense.
vikas mahajan Feb 28, 2018 2:58 AM (in response to Diiip Kumar )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.
Diiip Kumar Feb 28, 2018 3:33 AM (in response to vikas mahajan)Qliksense 3.2 SR4
-
-
Re: By Expression color in qliksense.
Mohammed Mukram Ali Feb 28, 2018 3:01 AM (in response to Diiip Kumar )Hi,
can you attach sample file let me check the if condition
Thanks,
Mukram.
-
Re: By Expression color in qliksense.
Diiip Kumar Feb 28, 2018 3:36 AM (in response to Mohammed Mukram Ali)we can not attach the file . its confidential
-
-
-
Re: By Expression color in qliksense.
Diiip Kumar Mar 1, 2018 1:51 AM (in response to Mohammed Mukram Ali)Thank you for your reply.
I'm using in Dimension.
-
-
Re: By Expression color in qliksense.
vivek anand Mar 1, 2018 2:36 AM (in response to Diiip Kumar )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.
Diiip Kumar Mar 1, 2018 2:45 AM (in response to vivek anand)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)+')))
Please suggest.
-
Re: By Expression color in qliksense.
vivek anand Mar 1, 2018 2:57 AM (in response to Diiip Kumar )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
-
Re: By Expression color in qliksense.
Diiip Kumar Mar 1, 2018 3:42 AM (in response to vivek anand)i tired no results..
-
-
-