SET ANALYSIS ONLY FOR SELECTED DIMENSION

[satishkurra]

HI All

I have a situation where the selection on the dashboard should happen only for project dimension and not for all other dimensions.

Hence i'm using the below expression.

=Only({1<[Project Name]=P([Project Name])>}CountyBoundary)

I believe the above is correct.

The problem is when i change my dimension from CountyBoundary to Only(CountyBoundary), the boundaries are disappearing.

Can someone help on the same.

In b/w i'm using QlikMaps extension object...

Thanks

Satish

[sunny_talwar]

Is this a dimension or expression? If this is a dimension, you might need to use the Aggr() function:

Aggr(Only({1<[Project Name] = p([Project Name])>} CountyBoundary), CountyBoundary)

[satishkurra]

Hi Sunny

Thanks. It worked.

Sorry for the late Response

Thanks

Satish

[sunny_talwar]

Awesome

If you got what you wanted, would you mind closing this thread by marking correct answer.

Best,

Sunny

[satishkurra]

Done. Updated