topic Re: Drill down Dimension in Aggr expression in App Development

Drill down Dimension in Aggr expression

siva0606 — Tue, 30 Nov 2021 16:25:32 GMT

Hi All,

I am using the below expression for one of my calculation and using two fields in dimension.

1. Product is a field

2. Level is a drill down dimension.

=Sum(Aggr(((Sum({<Year={$(=Max(Year))}>}Sales)+$(vBudget))/Count(Distinct {$<Year={$(Max(Year))}>} Date))*6,Product,

$(='[' & GetCurrentField([Level]) & ']')))

Kindly correct me if the above expression is wrong.

Best Regards,

Siva

Re: Drill down Dimension in Aggr expression

stevejoyce — Wed, 11 Aug 2021 13:15:52 GMT

Are you in View or Sense? That would work in View. GetCurrentField is not available in Sense. You can use an if-statement to mimic the getcurrentfield logic, or i just learned the other day of using GetObjectDimension. If your Level drill down dimension can't change order you can use this as you'll know the dimension index of it.

Otherwise you can reference this workaround with a variable:

https://community.qlik.com/t5/New-to-Qlik-Sense/GetCurrentField-in-Qlik-sense/td-p/909450

Re: Drill down Dimension in Aggr expression

siva0606 — Wed, 11 Aug 2021 13:18:46 GMT

Hi ,

I am using Qlikview. But the above expression is not working as expected.

Best Regards,

Siva

Re: Drill down Dimension in Aggr expression

Kushal_Chawda — Wed, 11 Aug 2021 14:07:57 GMT

@siva0606 I don't see any issue in your expression. Probably you can share sample data in expected output

Re: Drill down Dimension in Aggr expression

rwunderlich — Wed, 11 Aug 2021 14:30:49 GMT

You generally don't need to use GetCurrentField. You can just specify the group name as an Aggr dim. ie

Product, Level

-Rob

Re: Drill down Dimension in Aggr expression

siva0606 — Wed, 11 Aug 2021 15:06:32 GMT

@rwunderlich Thank you so much.

Best Regards,

Siva