Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
jblomqvist
Valued Contributor

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

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?

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
jblomqvist
Valued Contributor

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

Perfect, you are a star Gysbert!

Highlighted

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

Thx Gysbert.

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

Highlighted
carlcimino
Contributor II

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

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

Highlighted
carlcimino
Contributor II

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

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