Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

11 Replies
vanand3535
Creator III
Creator III

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

Anonymous
Not applicable
Author

i tired no results..