Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How do aggregate by one dimension, ignoring current selection

Hi all,

I have a chart with two dimensions - Device platform and age. And in one of the measures, I want to display total user count for each age dimension for the month, no matter what my device platform selection is.

So my expression is : COUNT(    {1<month_id = P(${month_id})>}   TOTAL <age>   user_id).

The problem is that this expression still respect device platform selection.

Any suggestions? 

Thanks

5 Replies
MVP
MVP

Re: How do aggregate by one dimension, ignoring current selection

What do you want to achieve with

COUNT(    {1<month_id = P(${month_id})>}   TOTAL <age>   user_id)

Do you maybe need something like

COUNT(    {1<month_id = P( month_id )>}   TOTAL <age>   user_id)

Not applicable

Re: How do aggregate by one dimension, ignoring current selection

Hi

Thanks for the reply.

This is used to calculate a denominator in my metrics. Basically I want this number to be the number of users for every age, ignoring my selection (keep the month_id selection though)

MVP
MVP

Re: How do aggregate by one dimension, ignoring current selection

If device platform selection alters the possible values of month_id, this will also alter your expression result.

Not applicable

Re: How do aggregate by one dimension, ignoring current selection

in the data I imported, the platform selection won't alter month_id value.

I tried to do SUM(AGGR()). But the i don't know if there is anyway to ignore selection in AGGR(). The set Analysis before AGGR() won't work.

MVP
MVP

Re: How do aggregate by one dimension, ignoring current selection

This may explain set analysis / advanced aggregation.

Set Analysis in the Aggr function

Could you post a small sample application that demonstrates your issue?