topic Set Analysis - PrevMonth with unselected fields in QlikView

Set Analysis - PrevMonth with unselected fields

Tue, 02 Nov 2010 22:38:03 GMT

I have to fields for selecting months: Month (1,2,...), MonthName (Jan,Feb,..). Now I wan to select Previous Month in the chart

sum({$<Month={$(=Only(Month)-1)}>}Amount)

But my selections are in MonthName field not in Month. How can I refer to Previous Month if I have to select month in MonthName not in Month field? I mean when I select February, I want to show January too?

Set Analysis - PrevMonth with unselected fields

Oleg_Troyansky — Wed, 03 Nov 2010 00:07:03 GMT

Add another Set Modifier to ignore user selection in MonthName, and everything will work:

sum({$<Month={$(=Only(Month)-1)} , MonthName= >}Amount)

Set Analysis - PrevMonth with unselected fields

llauses243 — Wed, 03 Nov 2010 00:22:36 GMT

Hi Pedro,

This is my offer (see .zip)

Good Luck

/Luis.