Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You generally don't need to use GetCurrentField. You can just specify the group name as an Aggr dim. ie
Product, Level
-Rob
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
Hi ,
I am using Qlikview. But the above expression is not working as expected.
Best Regards,
Siva
@siva0606 I don't see any issue in your expression. Probably you can share sample data in expected output
You generally don't need to use GetCurrentField. You can just specify the group name as an Aggr dim. ie
Product, Level
-Rob