Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
albertestrada
Contributor II
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
sunny_talwar

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]))

View solution in original post

1 Reply
sunny_talwar

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]))