Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
albertestrada
New Contributor II

Ignoring Specific Filters

Hello,

Can someone provide guidance on how to ignore specific filters in a Aggr function & set analysis? I am calculating a 12 month rolling sum of revenue in a bar chart.  I would like for the chart to display the 12 months based on the Month selected.

I would like to ignore Fiscal Quarter and Fiscal Year

Dimension:

Fiscal Month

LVL_2

Measure:

Aggr(RangeSum(Above( sum({<[Fiscal Quarter]=,[Fiscal Year]=,ADJ_CNL_IND_LVL_1={'ACC'}>} REV_AMT),0,12)), LVL_2,[Fiscal Month])

1 Solution

Accepted Solutions

Re: Ignoring Specific Filters

Try this

Only({<[Fiscal Quarter], [Fiscal Year]>} Aggr(RangeSum(Above(Sum({<[Fiscal Quarter], [Fiscal Year], ADJ_CNL_IND_LVL_1 = {'ACC'}>} REV_AMT), 0, 12)), LVL_2, [Fiscal Month]))

1 Reply

Re: Ignoring Specific Filters

Try this

Only({<[Fiscal Quarter], [Fiscal Year]>} Aggr(RangeSum(Above(Sum({<[Fiscal Quarter], [Fiscal Year], ADJ_CNL_IND_LVL_1 = {'ACC'}>} REV_AMT), 0, 12)), LVL_2, [Fiscal Month]))