Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kennethholden
Contributor

hmmmm....

(sum({1<[FIS YEAR]={'2017'}>} UNITS))-(sum(UNITS))

This should give me all of 2017 units, ignoring dimension selection, minus 2018 units.......but it does not, in fact, it does not subtract at all.

just get 2017 total units. zits as if it completely ignores the subtraction.

what am I doing wrong?

Thank you.

2 Replies
MVP
MVP

Re: hmmmm....

To ignore the "selections" that the dimensions do you will have to use the TOTAL qualifier in the aggregations. The 1 set identifier will affect the normal user selections and won't affect the dimension "selections"/groupings.

MVP
MVP

Re: hmmmm....

(Sum(TOTAL <Dim1> {1<[FIS YEAR]={'2017'}>} UNITS))-(Sum(TOTAL <Dim1> {1} UNITS))

This is how it's done keeping one (grouping) dimension but ignoring the rest of the dimensons.

Community Browser