How to use a Drill-Down Group in an AGGR expression for a chart?

[jblomqvist]

Hi all,

How can I use a Drill Down Group in an Aggr Expression?

The Drill Down is called Time consisting of fields Year, Quarter, and Month.

E.g. I have a Bar Chart that uses Drill Down dimension and expression of Sum(LineSalesAmount).

I need to use it in an AGGR function now, how can I write it please?

[Gysbert_Wassenaar · Accepted solution]

Something like this perhaps: aggr( ...expression..., $(='[' & GetCurrentField([GroupNameHere]) & ']'))

[jblomqvist]

Perfect, you are a star Gysbert!

[Anonymous]

Thx Gysbert.

Just did a quick search on this forum, this thread popped up and was exactly the solution I was after.

[carlcimino]

Hi trying to implement this solution...  I want to replace DEPT_LVL5_DESC with a drill group called Dept Top 10.  I've tried copying and pasting  $(='[' & GetCurrentField([Dept Top 10]) & ']')) everywhere DEPT_LVL5_DESC was but it didn't work.  Any suggestions?  Thanks.

Drill Group

=if(
aggr(
rank(
($(v_BkdExp_CY_PTD)-$(v_BudgetExp_CY_PTD)),4,1),
[DEPT_LVL5_DESC])<=5,
[DEPT_LVL5_DESC]
,
if(
aggr(
rank(
-($(v_BkdExp_CY_PTD)-$(v_BudgetExp_CY_PTD)),4,1),
[DEPT_LVL5_DESC])<=5
,[DEPT_LVL5_DESC]))

[carlcimino]

No wonder it isn't working. Qlik Sense does not support GetCurrentField().  Boo!