Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignore filters to calculate (Sub)total based on 1 dimension with set state

Hi Folks,

I'm struggling to find the right solution to my problem.

I need to calculate a subtotal of sales (Total Net Distribution Sales) based on a dimension (Global BU) and inclusive of a set state (Period1) - ignoring all other filters

The below does the trick with regards to dimension and set state, but is still impacted by other filters

=sum( TOTAL {Period1*<[Global BU]=$::[Global BU]>} [Total Net Distr Sales])

Can you help?

Many Thanks!

0 Replies