0 Replies Latest reply: Jul 13, 2017 5:22 AM by ibrahibra aljefri RSS

    colormix1 function

    ibrahibra aljefri

      hi,

      i am using qlik sense desktop  , i am using pie chart with drill down dimesions and want to give proper color to each drill down and below expresion is not working with me

       

      if ([Channelfilter] or [Application Status],

      ColorMix1([Application Status]= '' or [Channelfilter] = '' ,

      if([Application Status]='Invalid' or [Channelfilter]= 'Agency'    ,RGB (196,215,155),

      if([Application Status]='valid'   or [Channelfilter]= 'Telesales' ,RGB(230,184,183),

      if([Channelfilter]= 'D-sales'                                     ,RGB(90, 240, 96),

      if([Channelfilter]= 'HO'                                          ,RGB(184, 204, 228),

      if([Channelfilter]= 'Showroom'                                    ,RGB(204, 192, 218),

      RGB(90, 240, 96))))))) 

      ,RGB(230,184,183))