topic Square brackets in getcurrentfield func in QlikView

Square brackets in getcurrentfield func

Anonymous — Sun, 17 Sep 2017 14:07:54 GMT

Hi all.

Does anyone has problem with calculation getcurrentfild value, using in aggregation function?

My test dimensions, contained in cycle group are:

Company id,

Customer id

That's why i tried to use square brackets in the expression:

sum(aggr(sum(Sales), '['&GetCurrentField("Test")&']'))

Thanks for advices.

There's model and source file in the attachment. !

Re: Square brackets in getcurrentfield func

swuehl — Sun, 17 Sep 2017 14:18:53 GMT

Try a dollar sign expansion:

sum(aggr(sum(Sales), $(= '['&GetCurrentField("Test")&']') ))

Re: Square brackets in getcurrentfield func

Anonymous — Tue, 05 Jun 2018 12:12:03 GMT

I see original user did not reply, but thanks for this, Stefan. My drill down groups were not working in a scatter chart past a certain dimension, and I noticed that it started to happen when the dimension name had a space in it (which I generally try to avoid, but this was an external data set with some constraints around naming conventions). By concatenating brackets into the expression string, it solved the issue. If anyone else is using GetCurrentField in a drill down group and getting a "No Data to Display" error, I recommend checking spelling and case in the group fields, and if all is well there, try this if you have a space in the field name.