topic Re: Set Analysis forces chart to display data disregarding filters in App Development

Set Analysis forces chart to display data disregarding filters

tschullo — Wed, 27 Apr 2022 19:54:04 GMT

I have run across this issue before:

I have a chart that shows data for restricted by set analysis in the expression definition, for example:

Sum({<Category={"A","B"}>} Sales)

If a user then uses a filter to attempt to only display Category A, the chart ignores the filter.

My solution has always been to add a new field in script that captures those two categories as one, for example CatAB='Y'.
I can then modify the expression to Sum({<CatAB={"Y"}>} Sales) and now it respects the user filtering by Category.

Is there no other simpler way to handle this? I'm still not clear on why set analysis behaves this way. Seems a bit overbearing.

Re: Set Analysis forces chart to display data disregarding filters

Digvijay_Singh — Wed, 27 Apr 2022 21:28:39 GMT

not sure but try this may be -

Sum({<Category={'A','B'}>*<Category=P(Category)>} Sales)

Re: Set Analysis forces chart to display data disregarding filters

Clever_Anjos — Wed, 27 Apr 2022 22:52:15 GMT

Add a star before the = sign

Sum({<Category*={"A","B"}>} Sales)

Re: Set Analysis forces chart to display data disregarding filters

tschullo — Wed, 27 Apr 2022 22:57:26 GMT

Thanks!