Date comparison in graph - xml publisher

Question

Summary Date comparison in graph - xml publisher Content Hi, i need to create a line graph showing some field values against date. i need to test if date value is greater than current month then line should stop displaying further. e.g. A'cumulative line(red) should disappear after jun 17. PFB, code snippet

any solutions??????? Best Regards, Shaikh

Thomas Dodds · Answer

evaluate the date if less than or equal to your 'target' date do the sum else NULL ... don't sum a null

OR

sum it up for every date (and get the flat line like you have) then wrap that sql with a case when the date >= target then use the null and not the re-summed value

wrapping a SQL:

SELECT x.DATE,

CASE WHEN x.DATE >= 'DD-MON-YYYY' THEN NULL ELSE VAL END VAL

FROM (

SELECT DATE, SUM(VALUE) VAL FROM TABLE GROUP BY DATE) x

Zshaikh · Answer

Hi Thomas,

Thanks for responding.

i tried setting null values for future dates but we are using sum() to get cumulative value hence it gives 0 instead of Null.

any inputs????

Regards,

Zeenat

Thomas Dodds · Answer

Do it in the query ... any value above your date set to NULL ....