topic Re: using dimension in expresion in QlikView

using dimension in expresion

shayraber — Sun, 08 Apr 2018 15:20:46 GMT

hi all,

assuming i have a table with one dimension and one expression (which is aggr function).

the dimension is set up to be as a group dimension (so i can't tell which one the end user will choose).

can I use the dimension at the expression (aggr)? like using the first expression as 'Column(#)'?

i wish to build an aggr expression which will be based on the table's dimension. possible?

thanks,

MK_QSL — Sun, 08 Apr 2018 17:16:50 GMT

Not understood your requirements fully.

But you can check below one..

MarcoWedel — Sun, 08 Apr 2018 21:35:19 GMT

Hi,

maybe you could use

$(=GetCurrentField(YourGroupName))

as dimension parameter of your Aggr() function.

hope this helps

regards

Marco

shayraber — Sun, 08 Apr 2018 22:07:33 GMT

thanks.

it worked