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

    By Expression color in qliksense.

    Diiip Kumar

      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.