Highlight multiple max value in histogram

Tue, 09 Apr 2013 13:22:19 GMT

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 :

(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,

topic Highlight multiple max value in histogram in QlikView

Highlight multiple max value in histogram