Date Dimension Limited to Possible Only

Anonymous — Thu, 09 Aug 2012 20:40:30 GMT

In my chart, I have two dimensions: Customer and Quarter

I want to only show the calendar's possible Quarters based on the max date. Primarily because without doing this my expression shows a row/column of 0's because of no data.....because it is in the future.

So how do you exclude future dates if your dimension is

For example:

Year = 2012

Today = 08/09/2012

Possible dates = everything before 'today'

Month = August

Possible months = everything from August to January (January representing the lowest possible month given the max year of 2012)

Quarter = 3

Possible quarters = 1, 2, and 3 -----> not 4 because the highest date has determined it hasn't happened yet

Re: Date Dimension Limited to Possible Only

MayilVahanan — Thu, 09 Aug 2012 21:03:01 GMT

Try like this,

= if you have date field,

=Sum({<DateField = {'>=$(=MonthStart(Min(DateField)))<=$(=Date(Today()))'}>}Sales)

Hope it helps

topic Re: Date Dimension Limited to Possible Only in QlikView

Date Dimension Limited to Possible Only

Re: Date Dimension Limited to Possible Only