Expression Editor - Condition for Bar Chart

[pentaloc]

Hi,

 

I want to create a bar chart to compare two different years. 

There is only one sql query and one year parameter ($P{year}) because I think only one Dataset can be used for a chart. (If not I would use two datasets with two different year parameter…)

 

Here is my category series for the current year:

Series expression: $P{year}

Category exp: $F{year}.compareTo($P{year})?$F{month}:"nothing"

Value expression: ${sales}

 

It works fine and I get all the right bars but there is one bar with the label “nothing” and the value of a other year. I don’t want this additional bar :P

How can I solve this? Need more info?^^

Post Edited by pentaloc at 07/06/2012 06:59

[pentaloc]

- solved -