topic Set Analysis - Previous YTD excluding Month selections in QlikView

Set Analysis - Previous YTD excluding Month selections

Wed, 22 Jul 2009 13:56:49 GMT

Hi Guys,

Below is my set analysis expression to calculate Previous Year Total.

Sum({$<[FinYear]={$(=max([FinYear])-1)}>} GLTranAmount)

Within my model, I'd like to exclude all selections based on Month.

This will ensure that a the Previous Year Total will only change when a different year is selected, i.e. it is a static total by year and not a rolling Previous Year YTD.

I've looked at Set Identifiers to exclude Month selection(s) but to no avail.

Does anyone have a solution?

Thanks in advance.

Set Analysis - Previous YTD excluding Month selections

Wed, 22 Jul 2009 14:13:37 GMT

Hi,

Try using the below formulae.

Sum({$<[FinYear]={$(=max([FinYear])-1)},Month = >} GLTranAmount).

- Sridhar

Set Analysis - Previous YTD excluding Month selections

Wed, 22 Jul 2009 14:52:18 GMT

Thanks, works a treat.

I had the correct syntax but was placing it before the {$<[FinYear={$(.... condition.