topic Re: set analysis in dimension in QlikView

set analysis in dimension

saumyashah90 — Fri, 06 Nov 2015 09:56:59 GMT

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

Anonymous — Fri, 06 Nov 2015 09:59:35 GMT

what is your requirement?

swuehl — Fri, 06 Nov 2015 10:01:07 GMT

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 — Fri, 06 Nov 2015 10:24:47 GMT

Add in your expression:

{$ <RM_Name=,PC_Code=>}

let me know