Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

carm-1988
New Contributor

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!

2 Replies

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

How about this?

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

carm-1988
New Contributor

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

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

Community Browser