1 Reply Latest reply: Apr 28, 2016 3:35 PM by Sunny Talwar RSS

    Verify the colour code expr

    Subba Reddy

      Hi Folks,

       

      can any one help with below Qlik Sense expr..

       

      Below expr geting 0.80 is showing as red, as per below expr it should show green colour..

       

      =If(

      (

      IF(Count({<[T1 >= 7days (Start Work ~ OnWatch)]={'0'},[Type 1 Count]={'1'}>}Ticket)>0,

      Count({<[T1 >= 7days (Start Work ~ OnWatch)]={'0'},[Type 1 Count]={'1'}>}Ticket))

       

       

      /(

      IF(Count({<[Type 1 Count]={'1'}>}Ticket)>0,

      Count({<[Type 1 Count]={'1'}>}Ticket)

      )

      )

      )

      >=0.80,Green(),Red()

      )

        • Re: Verify the colour code expr
          Sunny Talwar

          Actually it is green when the expression is above 0.80. If it is below 0.80, the expression will show 0.80. May be change the order of Green and Red around?

           

          =If(

          (

          IF(Count({<[T1 >= 7days (Start Work ~ OnWatch)]={'0'},[Type 1 Count]={'1'}>}Ticket)>0,

          Count({<[T1 >= 7days (Start Work ~ OnWatch)]={'0'},[Type 1 Count]={'1'}>}Ticket))

           

           

          /(

          IF(Count({<[Type 1 Count]={'1'}>}Ticket)>0,

          Count({<[Type 1 Count]={'1'}>}Ticket)

          )

          )

          )

          >=0.80,Red(),Green()

          )