topic Re: Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis in QlikView

Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis

Anonymous — Mon, 12 Mar 2018 13:06:26 GMT

Hi experts,

I have a scenario where I want a filter selection to apply on a table measure based on a set analysis like this -

measure = Sum({$<PRODUCT_NAME = {$(vMarket1)}>} TRX)

The filter selection is on PRODUCT_NAME. Above measure is ignoring the filter selection on PRODUCT_NAME as it has been used inside set analysis expression. Could you please suggest a work around this ? Thanks!

Re: Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis

isingh30 — Mon, 12 Mar 2018 17:26:05 GMT

= Sum({$<PRODUCT_NAME = {'vMarket1'}>} TRX)

Re: Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis

sunny_talwar — Mon, 12 Mar 2018 17:32:35 GMT

May be this:

Sum({$<PRODUCT_NAME *= {$(vMarket1)}>} TRX)

Re: Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis

Anonymous — Mon, 12 Mar 2018 18:15:12 GMT

Hi Ishtdeep, vMarket is a variable so I am not sure how removing $ expansion would help.

Re: Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis

Anonymous — Mon, 12 Mar 2018 18:17:23 GMT

Thanks Sunny. That worked. Could you please help understand how adding an asterisk after field name made it abide the filter selection.

Is there any documentation around this which could help. Thanks!

Re: Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis

sunny_talwar — Mon, 12 Mar 2018 18:18:44 GMT

Yes, there is... check here

Implicit Set Operators

Re: Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis

Anonymous — Mon, 12 Mar 2018 20:06:11 GMT

Thank You Sunny!