6 Replies Latest reply: Jun 10, 2016 6:02 AM by Sunny Talwar RSS

    Qlikview bar chart background color issue

    Andrea Gigliotti

      Hello,

      I'm stuck with the below expression used in background color expression:

      ---

      If(

        Column(1) = Max( TOTAL Aggr(

        Sum( {< %CodiceCollaboratore -= {"000"}, %Data = {">=$(=AddMonths($(vStartA), -12))<=$(=vHeaderDataFineIms)"} >} QtaIms ), MeseAnno ) ),

        LightGreen(),

        if( Column(1) = Min( TOTAL Aggr(

        Sum( {< %CodiceCollaboratore -= {"000"}, %Data = {">=$(=AddMonths($(vStartA), -12))<=$(=vHeaderDataFineIms)"} >} QtaIms ), MeseAnno ) ),

        LightRed(),

        If( Floor(Max(%Data)) = Floor(MonthEnd(vHeaderDataFineIms)), $(vColor_State_B),

        RGB(214,231,248) ) ) )

      ---

      The Bar Chart unique dimension is "MeseAnno."

       

      The unique expression used in bar chart is:

      Sum( {< %CodiceCollaboratore -= {"000"}, %Data = {">=$(=AddMonths($(vStartA), -12))<=$(=vHeaderDataFineIms)"} >} QtaIms )

       

      I need to color Max and Min expression values in different colors.


      How can I achieve it ?

       

      Many thanks in advance.

       

      Best Regards

      Andrea