Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Something like this perhaps: aggr( ...expression..., $(='[' & GetCurrentField([GroupNameHere]) & ']'))
Something like this perhaps: aggr( ...expression..., $(='[' & GetCurrentField([GroupNameHere]) & ']'))
Perfect, you are a star Gysbert!
Thx Gysbert.
Just did a quick search on this forum, this thread popped up and was exactly the solution I was after.
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.
=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]))
No wonder it isn't working. Qlik Sense does not support GetCurrentField(). Boo!