Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Expression help

Hi,

I got this expression which return the right figures to me (so far so good)

sum(aggr(sum({<Crop={'*'}>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

I have a field/filter called 'CPM'

How do I implement that the figues returned from the expressions will be the same no matter what I select in 'CPM' ?

In other words: No mater what I select using CPM filter the figures calculated in my expression wont change.

Thanks in advance,

Kenneth

Tags (1)
1 Solution

Accepted Solutions

Re: Expression help

Try this:

=Sum({<CPM = >}Aggr(Sum({<Crop={'*'}, CPM =>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

5 Replies
maximiliano_vel
Contributor III

Re: Expression help

Try

=sum(aggr(sum({<Crop={'*'}, CPM>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

Re: Expression help

Try this:

=Sum({<CPM = >}Aggr(Sum({<Crop={'*'}, CPM =>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

MVP
MVP

Re: Expression help

try to disregard the filter on CPM

sum(aggr(sum({<Crop={'*'},CPM=>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

awhitfield
Esteemed Contributor

Re: Expression help

HI Kenneth,

try this:

sum(aggr(sum({<Crop={'*'},CPM=>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

Andy

awhitfield
Esteemed Contributor

Re: Expression help

That looks pretty conclusive! Ha ha!

Andy

Community Browser