Display data for maximum date per month

Mon, 21 Nov 2011 16:44:43 GMT

Hi,

I have set up a bar chart and I am trying to get it to graph the data for the maximum date available in each month (this is not always the last date of the month).

My dimension is (aggr(max(perioddate),month_var)) where month_var is a variable displaying the month of the perioddate variable.

My expression is sum({ $<perioddate= {'=aggr(max(perioddate),month_var)'}>} actual) where actual is the name of the variable I want to display in the bars.

Currently this is actually graphing the data value that corresponds to the minimum date each month but labelling it as the maximum date.

Can anyone help me fix this?

Thanks

topic Display data for maximum date per month in QlikView

Display data for maximum date per month