2 Replies Latest reply: Mar 19, 2017 1:27 PM by Petter Skjolden RSS

    Qlik Sense, custom colors by dimension

    Dushyant Patel

      I'm loading dimension from the database, dimension is a date value. I'm using following formula to change to 'MMM-YY', also shwon in the below image. =Date(monthstart(D_CREATE_DATE), 'MMM-YY')


      I'm having trouble to change the bar color for Mar-17.

      I'm using color by expression and using following formula, but I'm not able to change to color to green for dimension value of 'Mar-17'

      =If(Date(monthstart(D_CREATE_DATE), 'MMM-YY') = 'Mar-17', Green(), Red())


      Any help is appreciated.