Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

juriengroot
New Contributor III

Set analysis associated field

Hi,

I have a master calendar:

Load 

...

  (Year(TempDate)-1) * 12 + Num(Month(TempDate)) as MonthID,

  MonthName(TempDate) as Period

The user can select one Period in the app. I have two metrics:

Sum( {$<[MonthID]={$(=Max([MonthID]))} >} Money)

Sum( {$<[MonthID]={$(=Max([MonthID])-1)} >} Money)

If the user selects one Period, the 2nd metric shows 0. How can I let the user select one period and still show (essentially Period-1) via the monthID -1 ?

If I select one MonthID it works fine. Why can the set analysis not understand the associated field?

I don't want to have a data island btw.

1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis associated field

It does understand the associated field, but the user selection is incompatible with the field modifications. You need to clear the user selection in the Period field:

Sum( {$<[MonthID]={$(=Max([MonthID])-1)}, Period=  >} Money)

1 Reply
MVP
MVP

Re: Set analysis associated field

It does understand the associated field, but the user selection is incompatible with the field modifications. You need to clear the user selection in the Period field:

Sum( {$<[MonthID]={$(=Max([MonthID])-1)}, Period=  >} Money)

Community Browser