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