Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
shayraber
Creator
Creator

using dimension in expresion

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,

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe you could use

$(=GetCurrentField(YourGroupName))

as dimension parameter of your Aggr() function.

hope this helps

regards

Marco

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Not understood your requirements fully.

But you can check below one..

Customizable Straight Table

MarcoWedel

Hi,

maybe you could use

$(=GetCurrentField(YourGroupName))

as dimension parameter of your Aggr() function.

hope this helps

regards

Marco

shayraber
Creator
Creator
Author

thanks.

it worked