dimension totals

Tue, 24 Aug 2010 14:05:18 GMT

Hi, i have created a table that selects all the months for year 2010-2011 (year runs from april to march), three expressions are then calculated for these months (Chargeable, predicted, capacity).

This is all good except i would prefer to display all months for year 2010-2011 i only want to display the total for 2010-2011 for all three expressions.

Is this possible?

The diagram below illustrates the table and dimension already created and the bottom table displays how i would like it to be displayed.

dimension totals

Tue, 24 Aug 2010 14:42:30 GMT

You can modify your calculated dimension a bit and get that result. I was able to get it working on test data using:

=$(=Min({<Date={'>3/1/2010<4/1/2011'}>}Year(Date))) & '-' &
$(=Max({<Date={'>3/1/2010<4/1/2011'}>}Date(Date, 'YY')))

My date format is a little different than yours, but something like this should work:

=$(=Min({<[Month]={'>1/3/2010<1/4/2011'}>}Year([Month]))) & '-' &
$(=Max({<[Month]={'>1/3/2010<1/4/2011'}>}Date([Month], 'YY')))

topic dimension totals in QlikView

dimension totals

dimension totals