4 Replies Latest reply: May 22, 2017 5:37 AM by Supriya R RSS

    Bar graph:Customized colors for Different Dimension

    Supriya R

      Hi,

       

      I have a bar graph, where i am using customized color(gradient colors) for bars using expression

      Color Expression:  ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1 ,rgb(0,112,200),rgb(142,180,227),rgb(198,217,241))

      Dimension 1: Email Type

      Dimension 2: New Campaign Name

      Expression: Sum(emailValue)

       

      Color Expression got from qlikview.

      Capture123.PNG

       

      But, now my clients requirement as changed, and they ask me to get bar graph as show below, with gradient colors different for different dimension.

      Capture.PNG

       

      How could i apply different gradient colors as shown above graph?.

       

      Please help me on this. Any idea or suggestion is welcomed.