topic Re: Excluding a filter from my chart in App Development

Excluding a filter from my chart

ritvik4BI — Wed, 17 Feb 2021 08:10:57 GMT

Hi All,

I am trying to disable a particular filter i.e. Quarter in my chart but I want that my chart should continue to respond to other filters. I am trying to use set analysis.

The code I am writing is Sum( {<xyz, Quarter=>}Sales) where xyz is an expression which is correct.

But this is not working? The filter from Dimension Quarter is still active and filters my chart which I dont want. What am I doing wrong. Is there any alternative way to achieve this? Do let me know!!

Thanks.

Re: Excluding a filter from my chart

micheledenardi — Thu, 18 Feb 2021 08:14:45 GMT

Your expression seems correct.

Can you please post some example data and the full expression you're using?

Alternatively try to use this Sum( {<xyz, Quarter={"*"}>}Sales)

Re: Excluding a filter from my chart

MayilVahanan — Thu, 18 Feb 2021 09:12:07 GMT

Hi @ritvik4BI

where xyz is an expression which is correct.

If xyz is expression, u need to exclude Quarter in that expression too.