0 Replies Latest reply: Apr 9, 2013 9:22 AM by WANG Xu RSS

    Highlight multiple max value in histogram

      Hi, everyone,

       

      I'm new on qlikview, I have a histogram whose dimension is "MONTH_ID" varying from '01/01/2010' to '01/12/2013'. I have defined an expression sum(MONTHLY_FEE), and I want to highlight the max values of each year.

       

      I 've tried the function of backgroud color :

       

      if

      (SUM(MONTHLY_FEE)=Max(TOTAL {$<MONTH_ID={"=DATE('01/01/'&YEAR(MONTH_ID),'DD/MM/YYYY')<=DATE(MONTH_ID,'DD/MM/YYYY') AND DATE('01/12/'&YEAR(MONTH_ID),'DD/MM/YYYY')>=DATE(MONTH_ID,'DD/MM/YYYY')"}>} AGGR(Sum(MONTHLY_FEE),MONTH_ID)),RGB(0,255,0),RGB(255,0,0))

       

      But it highlights only the max value of all months, does anyone has some ideas?

       

      Regards,

      Xu