Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

Tags (2)
Community Browser