Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

AGGR function not working

HI All,

Below expression is not working for dimension giving NULL values please suggest what is wrong here. 

Dimension expression -

AGGR(Concat(DISTINCT dimen,' ,'&Chr(10)),AGGR(ONLY({name={'a','b'}>} name),name))

Labels (6)
1 Reply
edwin
Master II
Master II

in general, it would be hard to intelligently say what is wrong as someone would need sample data or at the least a picture of your DM to understand what is going on.  however, as a guess, i think it would fail here:

ONLY({name={'a','b'}>} name)

only will come back with a value if there is only one value for name however, you told it to pull 2 values a and b so it would come back with NULL