topic start and end dates in QlikView

start and end dates

Tue, 26 Mar 2013 09:42:34 GMT

Good morning

Posted a question about a rolling 12 month calculation which I've managed to get right now, using expression below. But now I'm unable to make any further selections i.e. select regions etc.

I'm wondering if I should use a variable to select a start and end date - are there any other options?

This is the expression I have for the rolling year.

count({1<DateRaised={">=$(=addmonths(monthend(max(DateRaised))+1,-12)) <=$(=max(DateRaised))"}StatusFlagID

)

Re: start and end dates

Tue, 26 Mar 2013 10:30:44 GMT

Try

count({$<DateRaised={">=$(=addmonths(monthend(max(DateRaised))+1,-12)) <=$(=max(DateRaised))"}StatusFlagID

)

The 1 or $ sign means that you base you calculation on the complete set of data (1) or the current selection ($). By using current selections ($), you can still change the region selections and such.

Re: start and end dates

Tue, 26 Mar 2013 15:27:56 GMT

Thanks that seems to be working find now, although I have noticed that when I select a region the date range changes which I assume has something to do with the $(=max(DateRaised)) part.