Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis - PrevMonth with unselected fields

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?



Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Set Analysis - PrevMonth with unselected fields

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

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

2 Replies
MVP
MVP

Set Analysis - PrevMonth with unselected fields

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

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

llauses243
Contributor III

Set Analysis - PrevMonth with unselected fields

Hi Pedro,

This is my offer (see .zip)

Good Luck

/Luis.

Community Browser