Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculated Filter Pane / Set Analysis - Can Only Select One Value

Hi there,

I am using the following for a calculated filter pane in Sense:

AGGR(Only({<Publisher_Code = {$(vOWNPUBCODE)}>} "My Publisher"),"My Publisher")

The problem I have is this will only permit selection of one value, or an invalid parameter error appears - probably due to the only function.

Does anyone have a solution / workaround?

Thanks!

Labels (1)
2 Replies
sunny_talwar

How about this?

Aggr(Only({1<Publisher_Code = {$(vOWNPUBCODE)}>} "My Publisher"),"My Publisher")

Anonymous
Not applicable
Author

Perfect, exactly what I needed!!! Thank you!!!!!