Only a small question, I've recently discovered the function getcurrentfield() for groups, so I'm trying to apply it to an expression that John Witherspoon kindly helped with.. But I don't get anything back... Instead of:
=aggr(linest_m(aggr(sum([PDI Data - Sale Price]),[PDI Data - Product Code],[PDI Data - Year Week]),[PDI Data - Year Week]),[PDI Data - Product Code])
I was thinking:
=aggr(linest_m(aggr(sum([PDI Data - Sale Price]),getcurrentfield(Selectors),[PDI Data - Year Week]),[PDI Data - Year Week]),getcurrentfield(Selectors))
But it doesn't do anything... Instead it doesn't bring back any results....
Getcurrentfield() returns a text literal. You want the actual field. For that, you simply use "Selectors". QlikView recognizes that Selectors is a group, and automatically uses the current field from the group.
Getcurrentfield() returns a text literal. You want the actual field. For that, you simply use "Selectors". QlikView recognizes that Selectors is a group, and automatically uses the current field from the group.
