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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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