Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

set analysis in dimension

i have PC_code and RM_Name in dimension as two different dimensions.

and i have expressions based on it in the straight table chart.

I have  both as filters also.

so when i click more on PC code or Rm name it should not change.

i tried = Only({<RM_Name=,PC_Code=>} PC_Code)

but showed error

3 Replies
Anonymous
Not applicable

what is your requirement?

swuehl
MVP
MVP

In a dimension, you want a dimensional construct, not a scalar.

Try with the aggr() function:

=Aggr( Only({<RM_Name=,PC_Code=>} PC_Code), PC_Code)

alexandros17
Partner - Champion III
Partner - Champion III

Add in your expression:

{$ <RM_Name=,PC_Code=>}

let me know