topic Re: How to use a Drill-Down Group in an AGGR expression for a chart? in QlikView

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

jblomqvist — Fri, 02 Sep 2016 12:35:49 GMT

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?

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

Gysbert_Wassenaar — Fri, 02 Sep 2016 12:42:31 GMT

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

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

jblomqvist — Fri, 02 Sep 2016 12:44:44 GMT

Perfect, you are a star Gysbert!

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

Anonymous — Mon, 19 Sep 2016 09:07:16 GMT

Thx Gysbert.

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

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

carlcimino — Wed, 30 Oct 2019 17:16:26 GMT

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]))

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

carlcimino — Fri, 01 Nov 2019 13:41:19 GMT

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