Qlik Community

Qlik Sense App Development

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

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
New Contributor III

Filter on calculated dimension in Qlik Sense

I have two related fields in my load script:




,round(fabs([Duration])) AS HedgeDurLong




,round(fabs([Duration])) AS HedgeDurShort

Then in my calculated dimension (a master item):

if(InvType = 'SWAP_IRS', HedgeDurShort, HedgeDurLong)

[Investment] has a 1 to many relationship with [Positions] (i.e., one investment can have many positions).  Using my master item, I am able to make charts/pivots with it just fine.  But I cannot use this dimension as a filter.  I click on it, the UI flashes, and refuses to filter the data.  What's going on?

Community Browser