Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to use only in dimension side

Hi All,

I need to use only() function in dimension side.

For EX: If I will select B option and field A is having only 1 value related to B then it should display A/B like that.

1 Reply
Chanty4u
MVP
MVP

try in dim:

=aggr(only(Dim1),Dim1,Dim2)